0
0
Excelspreadsheet~10 mins

TEXT formatting for dates in Excel - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This data shows three dates in ISO format (year-month-day).

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
    A   
  +-----------+
1 | 15-Jun-2024 |
  +-----------+
The formula references cell A1 which contains the date to format.
Result
    B                      
  +-------------------------+
1 | Saturday, June 15, 2024 |
  +-------------------------+
The formula result in cell B1 shows the date from A1 formatted as a readable text string with weekday, 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 month number
BShows the day number only
CShows the full weekday name like Saturday
DShows the year in two digits
Key Result
TEXT(date_cell, "format_string") converts a date to text with the specified date format.