Skip to main content

EDATE

Use the EDATE function to modify dates by a specified number of months.

Use

EDATE( start_date, months )
Returns the date adjusted by the number of months before or after the start date.

ParameterRequiredDescription
start_dateYesa date that represents the start date
monthsYesthe number of months before (negative) or after (positive) the start_date

ReturnsDate

Example

This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.

ON THIS PAGE