The EDATE function returns the date which is the number of months after or before from the date which you specify.
For example, if you specify date 01-Apr-2016 and 5 as a month number, it will return 1-Sep-2016 in the result as September is exactly 5 months after April.
You can use EDATE while calculating maturity dates and for defining deadlines for tasks.
Below we have used EDATE with different types of arguments.
Note: EDATE is quite smart to give you the same date in future and past. It doesn’t matter that there are 31 days, 30 days or 28 days in a month.