EDATE Function

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.


  =EDATE(start_date, months) 


  • 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.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Send this to a friend