Date & Time
Add Months to a Date
Add a specific number of months to a date using EDATE. Handles month-end dates correctly (e.g., adding 1 month to Jan 31 gives Feb 28).
Excel Formula
=EDATE(A2, B2)Step-by-Step Explanation
1
EDATE adds months to a date
2
A2 is the starting date
3
B2 is the number of months to add (negative to subtract)
4
Handles end-of-month dates correctly
5
Jan 31 + 1 month = Feb 28 (or 29 in leap years)
Example
| Start Date (A) | Months (B) | Result Date (C) |
|---|---|---|
| 1/15/2026 | 3 | 4/15/2026 |
| 1/31/2026 | 1 | 2/28/2026 |
| 6/10/2026 | -2 | 4/10/2026 |
Result: Formula in C2: =EDATE(A2,B2) → 4/15/2026
Common Variations
Without EDATE
=DATE(YEAR(A2),MONTH(A2)+B2,DAY(A2))Manual calculation using DATE
Add years
=EDATE(A2,B2*12)B2 = years to add
Need a Custom Version?
Use our AI generator to create a formula tailored to your specific data and requirements.
Try It with AI →