Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
EDATE
EDATE shifts a date forward or backward by a whole number of months, preserving the day-of-month where possible (clamping to the last day of the month when needed). It is ideal for calculating subscription renewals, loan maturity dates, or any recurring monthly schedule.
Excel
=EDATE(DATE(2024,1,31),1)Google Sheets
=EDATE(DATE(2024,1,31),1)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| StartDate | Months | RenewalDate |
| 2024-01-31 | 1 | |
| 2024-03-15 | 6 | |
| 2024-08-31 | 3 | |
| 2023-11-30 | 12 |
=EDATE(DATE(2024,1,31),1)→45350
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Place your start date in cell A2 and the number of months to add (or subtract with a negative value) in B2.
- 2In C2 type =EDATE(A2,B2) to get the resulting date.
- 3Format the result cell as a date so it displays correctly rather than as a serial number.
Need a version for your data?
Try: “Calculate the renewal date that is exactly 6 months after each subscription start date”