Skip to content

Add months to a date

Move a date forward or back by whole months, for renewals and due dates.

The formula

Argument separator
Excel and Google Sheets
=EDATE(A2, B2)

How it works

  1. A2

    The starting date.

  2. B2

    How many months to add. Use a negative number to go back.

Example

A: StartB: MonthsC: Result
2026-01-1532026-04-15
2026-01-3112026-02-28

Tips

  • Format the result as a date if it shows a number like 46127.