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)



ADVERTISEMENT
ADVERTISEMENT