The EDATE function in Excel takes a date and adds specified number of months. The returned result defaults as a serial date. For this reason, the returned cell needs to be formatted as a date.

Syntax:

  =EDATE(start_date, months) 

Arguments

  • start_date – (required) Must be valid starting date
  • months – (required)

EDATE Function in Excel Usage Example:

Looking at the following example, you can see how are adding 6-months and 12-months as as well as subtracting 6-months and 12-months respectively. The individual results are below.

EDATE Function in Excel

Usage Errors

If the result cell is not formatted as a date, the returned value will be a serial date.