It returns the date that is a given number of months before or after the specified date.
The syntax of the function is the following:
EDATE(start_date, months)
start_date: The start date.
months: The months before (negative value) or after (positive value) the start_date. If it is not an integer it is truncated.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the EDATE function:
In the cell Α2 calculate the date of the cell A1 increased by one month exactly, using the proper function.