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.
Syntax
EDATE(Start_Date, Month)
Parameter
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.
Category
Date & Time
Return
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) |