The Excel Edate function returns a date that is a specified number of months before or after a supplied start date.
The syntax of function is:
Where the arguments are as follows:
|start_date||-||The initial date, from which to count the number of months.|
|months||-||The number of months to add to (or subtract from) the start_date.|
Note that Microsoft advises that you do not type dates directly into functions, because Excel interprets text representations of dates differently, depending on the date interpretation settings on your computer. Therefore the start_date argument for the Edate function should be input as either:
Warning: Although you can input date arguments as date serial numbers, this is not recommended as date serial numbering does vary across different computer systems.
The following spreadsheets show examples of the Edate function. The formulas are shown in the spreadsheet on the left, and the results are shown in the spreadsheet on the right.
The above examples illustrate that:
Note also that, as recommended by Microsoft, in all calls to the Edate function, the start_date has been supplied as a cell reference.
Further examples of the Excel Edate function can be found on the Microsoft Office website.
If you get an error from the Excel Edate function, this is likely to be one of the following:
|#VALUE!||-||Occurs if either:|
Occurs if the Analysis ToolPak add-in is not enabled in your Excel.