Shift a date forward or back by a number of months with EDATE.
Copy this formula
=EDATE(A2, 3)EDATE returns the date a given number of months before or after the start date — use a negative number to go back. It handles month-end and leap years correctly, unlike adding raw days.
=EDATE("2026-01-31", 1)→2026-02-28One month after Jan 31 lands on Feb 28.
End of the month
=EOMONTH(A2, 3)Returns the last day of the month 3 months out.
Months vary in length, so +30 days drifts. EDATE keeps the same day-of-month and respects month ends.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.