0
0
Google Sheetsspreadsheet~10 mins

EDATE and EOMONTH in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Dates in column A and month offsets in column B. A1 is January 15, 2024; A2 is March 31, 2024. B1 and B2 are month numbers to add or subtract.

CellValue
A12024-01-15
A22024-03-31
B12
B2-1
Formula Trace
=EDATE(A1, B1)
Step 1: EDATE("2024-01-15", 2)
Cell Reference Map
2024-01-15
↓
2024-03-31
Formula uses A1 (start date) and B1 (months to add) as inputs.
Result
    A           B       C
1  2024-01-15    2    2024-03-15
2  2024-03-31   -1
Column C shows the result of EDATE(A1, B1), which is March 15, 2024.
Sheet Trace Quiz - 3 Questions
Test your understanding
What date does EDATE(A1, B1) return if A1 is 2024-01-15 and B1 is 2?
A2024-03-15
B2024-02-15
C2024-04-15
D2024-01-31
Key Result
EDATE(date, months) adds months to a date; EOMONTH(date, months) returns the last day of the month after adding months.