Kornilios Ampatzis/ May 2, 2019/ Functions

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:

Practice

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.

Share this Post