Skip to content
Google Sheets

EDATE function in Google Sheets

Returns a date a specified number of months before or after another date.

=EDATE(start_date, months)

EDATE syntax and parameters

Two arguments, two required.

  • start_dateanyRequired

    The date from which to calculate the result.

  • monthsnumberRequired

    The number of months before (negative) or after (positive) start_date to calculate.

EDATE examples

Formulas you'll actually reuse.

  1. Three months after the invoice date — a quarterly renewal:

    =EDATE(B2, 3)

    Result2026-11-14

  2. Month-end dates clamp instead of overflowing — 31 Jan + 1 month:

    =EDATE(DATE(2026, 1, 31), 1)

    Result2026-02-28

EDATE in Excel

Same name — your formula ports as-is.

Try EDATE in the playground

Edit the example — nothing to install.

Preloaded with the EDATE formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.