Excel EDATE() Function

Excel EDATE() Function

The EDATE() function in excel returns the serial number of the date that is the indicated number of months before or after the start date.


EDATE(Start_Date, Month)


Start_Date(required)- This parameter represents the date from which you calculate the before and after the date.

Month(required)- This parameter represents the month in numeric format.


Date & Time


This function returns the serial number of a particular date.

Example 1

Objective: To calculate the 3 months after the date indicated in the value cell.

Value Result Formula
11/12/2017 2/12/2018  =EDATE(A22,3)
10/22/2018 1/22/2019  =EDATE(A23,3)
7/24/2018 10/24/2018  =EDATE(A24,3)
10/22/2019 1/22/2020  =EDATE(A25,3)

Example 2

Objective: Get the date of 3 months ago from the date indicated in the value cell

Value Result Formula
11/12/2017 8/12/2017  =EDATE(A22,-3)
10/22/2018 7/22/2018  =EDATE(A23,-3)
7/24/2018 4/24/2018  =EDATE(A24,-3)
10/22/2019 7/22/2019  =EDATE(A25,-3)