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.