Excel EDATE Function: Complete Guide (2026)
ExcelFunction Reference⏱ 5 min read

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

EDATE(start_date, months)
ArgumentTypeDescription
start_date RequiredDateThe anchor date. Must be a real Excel date.
months RequiredNumberMonths to shift. Positive = forward, negative = backward. Non-integers are truncated.

Basic examples

3 months later

=EDATE("2026-01-15", 3)
Result: April 15, 2026

6 months earlier

=EDATE("2026-09-06", -6)
Result: March 6, 2026

1 year later (12 months)

=EDATE(A1, 12)
Same day of month, 1 year forward

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)
Result: February 28, 2026 (Feb 29 in a leap year)

Mar 31 + 1 month → Apr 30

=EDATE("2026-03-31", 1)
Result: April 30, 2026

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)
Anniversary of the start date, one year forward.

2. Monthly payment schedule

Rolling monthly due dates

=EDATE(originationDate, ROW() - firstRow + 1)
Fills a column with month-by-month due dates from origination.

3. Lease renewal notification (60 days out)

Warning date 60 days before renewal

=EDATE(leaseEndDate, 0) - 60
EDATE with 0 returns the same date; subtracting 60 gives the notification date.

4. Age at a specific milestone

When will someone turn 65?

=EDATE(birthDate, 65 * 12)
65 years × 12 months = 780 months from birth

5. Loan amortization dates

Payment date for month N

=EDATE(loanStart, paymentNumber)
Payment 1 → month 1. Payment 12 → month 12. Cleanly rolls forward.

6. Prior month same day

Comparison to prior month

=EDATE(TODAY(), -1)
Same day last month — great for "vs. same day last month" metrics

7. Year-over-year comparison

Same date last year

=EDATE(A1, -12)
Exactly one year prior

EDATE vs. EOMONTH vs. DATE

FunctionBehaviorBest 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

Serial number result

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.

Non-integer months

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.

Text dates

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).

EDATE for rolling forecasts

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

Related

EOMONTH

Like EDATE but returns the last day of the month.

Related

DATE

Construct dates from year, month, day.

Related

DATEDIF

Difference between dates.

Related

WORKDAY

For business-day math instead of calendar-month math.

Excel Wizard

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.