EDATE function
EDATE shifts a date by a whole number of months and returns a date serial number, keeping the day of the month where it can. It suits renewal dates, billing schedules and due dates.
Example
Read it as a sentence: take January 31, 2024 and move it forward 1 month, which gives the date serial number 45351.
A
B
C
D
1
45351
2
3
Syntax
EDATE(start_date, months)
-
start_date(required) - The starting date.
-
months(required) - Months to move; positive goes forward, negative goes back.
Returns: A date serial number the given number of months away.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=EDATE(DATE(2026,1,31),1) | 46081 | Month-end clamps |
=EDATE(DATE(2026,3,31),-1) | 46081 | Backwards |
=EDATE(DATE(2024,1,31),1) | 45351 | Into leap February |
=EDATE(DATE(2026,1,15),1.9) | 46068 | Fractional months |
=EDATE("1/31/2026",1) | 46081 | Text date |
=EDATE(DATE(2026,1,31),{1,2,3}) | 46081 | Array months |
=EDATE("x",1) | #VALUE! | Bad date |
=EDATE(DATE(2026,1,15),"x") | #VALUE! | Bad months |
Watch out for
- If the target month is shorter, the result falls on its last day (31 Jan plus 1 month is 29 Feb 2024).
- Returns a serial number, so format the cell as a date.
- Months is truncated, not rounded, if it has decimals.
Where it works
- Excel
- EDATE is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .