0
0
Google Sheetsspreadsheet~10 mins

DATE function in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Year, month, and day values to create a date.

CellValue
A12024
B16
C115
Formula Trace
=DATE(A1, B1, C1)
Step 1: DATE(2024, 6, 15)
Cell Reference Map
    A      B      C
1 [2024]  [6]    [15]
The formula uses cells A1 for year, B1 for month, and C1 for day.
Result
    D
1 [6/15/2024]
The formula in cell D1 shows the date June 15, 2024.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the DATE function do with the numbers 2024, 6, and 15?
AFormats the numbers as text
BAdds the numbers together
CCreates a date June 15, 2024
DIgnores the numbers
Key Result
DATE(year, month, day) creates a date from separate year, month, and day numbers.