The EDATE function returns the date before or after the specified months.
Formula:
=EDATE(start_date, months)
Explanations:
– Start_date is required, the start date you need to have the date months before or after.
– Months is required, the number of months you specified.
Cautions:
– Dates are stored as sequential serial numbers and January 1, 1900 is serial number 1.
– When the month is not an integer, it is truncated to use the integer.
