What is the EDATE Function
The EDATE function returns the date that is a specified number of months before or after a starting date. It keeps the same day of the month when possible. EDATE is very useful for calculating due dates, renewal dates, and maturity dates.
Formula: =EDATE(start_date, months)
Practical Example 1
A2 contains 15-Jan-2026. Add 3 months.
Type: =EDATE(A2, 3)
Result: 15-Apr-2026
Practical Example 2
Subtract 2 months from a date.
Type: =EDATE(A2, -2)
Result: the date 2 months earlier
Practical Example 3
Calculate a 6-month subscription renewal date.
Type: =EDATE(A2, 6)
Result: the renewal date
Practical Example 4
Calculate a 12-month maturity date for a fixed deposit.
Type: =EDATE(A2, 12)
Result: the maturity date
When to Use It
EDATE is used for invoice due dates, subscription renewals, loan maturity dates, contract end dates, and any business scenario where you need to add or subtract whole months from a starting date.