Question: how to use edate in excel?
Answer: Summary. The Excel EDATE function returns a date on the same day of the month, n months in the past or future. ... 
Shift date n months in future or past.
New date as Excel serial number.
=EDATE (start_date, months)
start_date - Start date as a valid Excel date. ... 
The EDATE function can add or subtract months from a date.