FAQ - EDate Formula in Excel
We also have Free
training videos on this site ( visit the
Home page
or the
Training Page) The edate formula refers to the usage of a function to handle dates as part of calculations in Excel. The edate formula thus returns a serial number. This serial number is the representation of the date indicated in the sum of months before and after the start date. The start date is used as the point of reference.
|
|
|
What is the usage then?
It is used to derive at the maturity dates which fall on the same day of the month as the date used as the issuing date.
What other functions are performed?
It can be used to derive at a date which represents a known total of months before or after the start date, thus in the future or past. It can thus be used for the expiring dates of a contract. An example of how the calculation will look like is provided below:
=EDATE(NOW(….) ,5)
|
|
If you want to calculate a date in the past you will use a negative value. To calculate a date in the future you will use a positive value as seen above. The edate formula for five months in the past will thus look like this:
=EDATE(NOW (….) , -5)
You will thus input the first date in the space between the brackets after the NOW function. The second parameter is for instance -5, which calculates the number of months in the past.
For more information on the edate formula and various other functions in Excel, click on our Training index.
|
