Skip to Content

EDATE

Returns the serial number of the date that is the indicated number of months before or after the start date

Syntax

EDATE(start_date, months)

Parameters

  • start_date: Required. A date that represents the start date
  • months: Required. The number of months before or after start_date (negative for before)

Example

=EDATE("1/15/2024", 3)
Returns: Date serial numberSince: Excel 2003