=EDATE (start_date, months)
Excel EDATE function can be used to add or subtract a specific number of months to a date. This excel formula helps in the calculation of due dates, expiry dates, and maturity dates. To get a future date we use positive values of months while the negative values of months are used to get the dates in the past.
What is the purpose of the Excel EDATE function?
The purpose of the Excel EDATE function is to get the same date in the past and future months.
What value will it return?
It returns us a serial number that represents a date.
In the below example, the formula used in E5 is
We have mentioned start date in C5 and the number of months to count in D5. We have got the result in E5 after adding or subtracting the number of months from the start date.
Figure 1 – Example of the use of Excel EDATE formula to get the desired dates in the past or future.
We have used positive values of months in D5, D7 and D8 to get the future dates, whereas, negatives values in D6, D9, and D10 for the months in the past.
Start_date: Representation of the start date in Excel’s serial number format. (Representing dates from C5 to C10 in our case).
Months: The number of months to calculate before or after start_date. (In our example, it is ranging from D5 to D10).
Excel EDATE function usage notes
EDATE is used to get the same date in the past or future months. For future dates, use a positive value of month such as (6), and for the past dates, use the negative value of the month as (-6).
EDATE is a clever function that rolls ‘end of month’ dates, in the normal and Leap years, and returns the dates after calculating them.