Excel EDATE Function: Complete Guide
EDATE adds (or subtracts) a whole number of months to a date, preserving the day-of-month. It's the "same day, N months later" function — perfect for renewals, anniversaries, and payment schedules. Unlike month overflow tricks with DATE, EDATE handles month-length differences correctly.
Syntax
| Argument | Type | Description |
|---|---|---|
start_date Required | Date | The anchor date. Must be a real Excel date. |
months Required | Number | Months to shift. Positive = forward, negative = backward. Non-integers are truncated. |
Basic examples
3 months later
=EDATE("2026-01-15", 3)
6 months earlier
=EDATE("2026-09-06", -6)
1 year later (12 months)
=EDATE(A1, 12)
Day clipping — the important edge case
When the target month is shorter than the start month's day, EDATE clips to the last valid day.
Jan 31 + 1 month → Feb 28
=EDATE("2026-01-31", 1)
Mar 31 + 1 month → Apr 30
=EDATE("2026-03-31", 1)
This is the correct behavior for "same day next month" logic. Renewals, payments, and anniversaries should clip, not roll over to the next month.
Common uses
1. Subscription renewal date
12-month subscription
=EDATE(startDate, 12)
2. Monthly payment schedule
Rolling monthly due dates
=EDATE(originationDate, ROW() - firstRow + 1)
3. Lease renewal notification (60 days out)
Warning date 60 days before renewal
=EDATE(leaseEndDate, 0) - 60
4. Age at a specific milestone
When will someone turn 65?
=EDATE(birthDate, 65 * 12)
5. Loan amortization dates
Payment date for month N
=EDATE(loanStart, paymentNumber)
6. Prior month same day
Comparison to prior month
=EDATE(TODAY(), -1)
7. Year-over-year comparison
Same date last year
=EDATE(A1, -12)
EDATE vs. EOMONTH vs. DATE
| Function | Behavior | Best for |
|---|---|---|
EDATE(A1, 3) | Same day, 3 months later. Clips if the day doesn't exist. | Anniversaries, renewals, monthly payments |
EOMONTH(A1, 3) | Last day of the month 3 months out. | Month-end reporting, invoice terms |
DATE(YEAR(A1), MONTH(A1)+3, DAY(A1)) | Overflows — Jan 31 + 1 month = Mar 3 (Feb 31 becomes March overflow). | Rarely — usually the wrong behavior |
Leap year handling
Add 12 months to Feb 29, 2024:
=EDATE("2024-02-29", 12)
Result: February 28, 2025 (2025 isn't a leap year, so clips to Feb 28).
Add another 36 months:
=EDATE("2024-02-29", 48)
Result: February 29, 2028 (leap year, so the original day is preserved).
Common pitfalls
If EDATE returns something like 46392 instead of a date, format the cell as Date. EDATE always returns a real date value — the display format determines what you see.
EDATE truncates decimals. =EDATE(A1, 2.7) is treated as =EDATE(A1, 2). To add half a month meaningfully, add days: =A1 + 45 for ~1.5 months.
Like other date functions, EDATE needs real dates. =EDATE("2026/09/06", 3) works in most locales but can fail with unusual formats. Wrap in DATEVALUE to be safe: =EDATE(DATEVALUE(A1), 3).
To build a 12-month rolling forecast, start with a single anchor cell = TODAY(). Fill down with =EDATE(anchor, ROW()-anchorRow). All forecast periods shift as time moves forward, no manual updates.
EDATE in Google Sheets
Google Sheets has an identical EDATE function. Same syntax, same clipping behavior, same leap-year handling.
Related functions
Rolling dates without the leap-year headaches
EDATE handles Feb 29 and month-length differences correctly. But knowing when to use EDATE vs. EOMONTH vs. DATE takes practice. Excel Wizard picks the right function for your intent — "next payment date, 1 month after last one" vs. "end of the invoice month".
Install Excel Wizard →Frequently asked questions
What does EDATE do in Excel?
EDATE adds (or subtracts) a whole number of months to a date, preserving the day-of-month. Syntax: =EDATE(start_date, months).
What does EDATE do when the day doesn't exist in the target month?
EDATE clips to the last valid day. =EDATE("2026-01-31", 1) returns Feb 28, 2026 (or Feb 29 in a leap year).
How do I calculate 12 months from a start date?
Use =EDATE(A1, 12). Cleaner than =DATE(YEAR(A1)+1, MONTH(A1), DAY(A1)) because EDATE handles leap-year edge cases.
What's the difference between EDATE and DATE+overflow?
DATE with month overflow rolls forward: Jan 31 + 1 month → Mar 3. EDATE clips: Jan 31 → Feb 28. For 'same day next month' logic, use EDATE.