0
0
Excelspreadsheet~10 mins

EDATE and EOMONTH in Excel - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Dates in column A and month offsets in column B for EDATE and EOMONTH functions.

CellValue
A12024-01-15
A22024-03-10
B11
B2-2
Formula Trace
=EDATE(A1, B1)
Step 1: A1
Step 2: B1
Step 3: EDATE("2024-01-15", 1)
Cell Reference Map
2024-01-15
↓
2024-03-10
EDATE uses the date in A1 and the month offset in B1.
Result
    A           B           C
1 2024-01-15    1     2024-02-15
2 2024-03-10   -2
The formula =EDATE(A1, B1) in cell C1 returns 2024-02-15, which is one month after the date in A1.
Sheet Trace Quiz - 3 Questions
Test your understanding
What date does =EDATE(A1, B1) return if A1 is 2024-01-15 and B1 is 1?
A2024-01-31
B2024-02-15
C2024-03-15
D2024-01-01
Key Result
EDATE(date, months) returns the date shifted by months; EOMONTH(date, months) returns the last day of the month shifted by months.