0
0
Google Sheetsspreadsheet~10 mins

TEXT formatting for dates in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This data shows three dates in ISO format (YYYY-MM-DD) in column A.

CellValue
A12024-06-15
A22024-12-01
A32024-01-09
Formula Trace
=TEXT(A1, "dddd, mmmm dd, yyyy")
Step 1: A1
Step 2: TEXT(2024-06-15, "dddd, mmmm dd, yyyy")
Cell Reference Map
2024-06-15
↓
2024-12-01
↓
2024-01-09
The formula references cell A1 which contains the date to format.
Result
    A                      B
1  2024-06-15    Saturday, June 15, 2024
2  2024-12-01    
3  2024-01-09
The formula in B1 shows the date from A1 formatted as a full weekday name, full month name, day, and year.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the "dddd" part in the TEXT formula do?
AShows the full weekday name like Saturday
BShows the month as a number
CShows the year in two digits
DShows the day without leading zero
Key Result
TEXT(date, "format") converts a date to text using the specified date format string.