Excel FunctionsExcel EDATE Function


Used to return the date after given number (n) months. For example, you are told that your 1st installment will be due in ten (10) months starting from next Monday (e.g. 25-Aug-1990).


The EDATE function syntax has the following arguments:

  • Start_date Required.

A date that represents the start date.

NOTE: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(1990,8,25) for the 25th day of August 1990. Problems can occur if dates are entered as text.

  • Months Required.

The number of months before or after start_date.

A positive value for months yields a future date whereas,

A negative value yields a past date.

Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.