EDATE Function will return a date which is the number of months after or before from a 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 Function while calculating maturity dates and for defining deadlines for tasks.
start_date A date from which you want to start.
months Number of months after & before you want to calculate.
Here I have used EDATE with different types of arguments.
EDATE function 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. You just have to mention the date and number of months.
To learn more about Excel EDATE Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.