Excel EDATE Function

Generic Formula

=EDATE (start_date, months)

Explanation

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.

Example

In the below example, the formula used in E5 is

=EDATE (C5,D5)

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.

Arguments

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.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar