What is the syntax of EDATE Function in Excel?

The Excel EDATE function returns a date on the same day of the month, n months in the past or future. You can use EDATE to calculate expiration dates, maturity dates, and other due dates. Use a positive value for months to get a date in the future, and a negative value for dates in the past.

  • Purpose: Shift date n months in future or past
  • Return value: New date as Excel serial number


=EDATE (start_date, months)


  • start_date - Start date as a valid Excel date.
  • months - Number of months before or after start_date.


If A1 contains the date February 1, 2018, you can use EDATE like this:

=EDATE(A1,1) // returns March 1, 2018 
=EDATE(A1,3) // returns May 1, 2018 
=EDATE(A1,-1) // returns January 1, 2018 
=EDATE(A1,-2) // returns December 1, 2017