Date & Timeintermediate
Calculate age in years with DATEDIF
=DATEDIF(A2,TODAY(),"Y")
Excel how-to guide
How to edate add months in Excel
Calculate contract expiry dates, subscription renewal dates, or payment due dates that fall a fixed number of months from a start date.
Step-by-step instructions
How to edate add months — 3 steps
1
Put the start date in column A.
2
Enter the number of months to add as the second argument. Use a negative number to subtract months.
3
EDATE returns a date serial number — format the result cell as a date.
Example data
Worked example
| Contract Start | Renewal Date (12 months) |
|---|---|
| 2024-01-15 | 2025-01-15 |
| 2024-06-01 | 2025-06-01 |
| 2024-11-30 | 2025-11-30 |
Common mistakes
Errors to watch out for
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.
FAQ
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.
Describe your exact spreadsheet problem — get the formula in seconds.
Open AI Formula Generator — FreeRelated how-to guides
Continue learning.
Date & Timebeginner
NETWORKDAYS for project timeline planning
=NETWORKDAYS(B2,C2)