Home/Formulas/Date/EDATE
Datemedium

EDATE()

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

Syntax
fx
=EDATE(start_date, months)
Arguments
ArgumentDescription
start_dateThe starting date.
monthsThe number of months before (negative) or after (positive) start_date.
Example
fx
=EDATE("2026-01-15", 3)

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and EDATE isn't one of them yet.

Related formulas
EOMONTH()
Returns the last day of the month a specified number of months before or after a date.
DATE()
Constructs a date value from year, month, and day numbers.
DATEDIF()
Calculates the number of days, months, or years between two dates.
Used by
DATEDIF()
Calculates the number of days, months, or years between two dates.
DATE()
Constructs a date value from year, month, and day numbers.
EOMONTH()
Returns the last day of the month a specified number of months before or after a date.
More Date formulas →Keyboard shortcuts for Sheets →