Date & Timebeginner
Add or subtract months from a date with EDATE
=EDATE(A2,12)
Function reference
EDATE in Excel & Google Sheets
EDATE is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.
1 beginnerBuild a custom EDATE formula →
When to use EDATE
- Calculate contract expiry dates, subscription renewal dates, or payment due dates that fall a fixed number of months from a start date.
Worked examples (1)
Common errors with EDATE
Result shows a number instead of a date
EDATE returns a date serial number. Select the result cell and format it as Short Date or your preferred date format.
EDATE is not available
In older Excel versions, EDATE requires the Analysis ToolPak add-in. In Excel 2010 and later it is built-in.
Frequently asked questions
How do I calculate the last day of a month N months away?
Use EOMONTH(A2, N) — it returns the last day of the month that is N months from the start date.
Need a custom variation?
Describe your specific EDATE problem and get a formula written for your exact data.
Open generator with EDATE