you might use EDATE to calculate expiration dates, maturity dates, and other due dates.
When 1 is given formonths, EDATE returns the same date in the next month.
Notice that EDATE automatically handles end-of-month dates properly, adjusting the day when needed to return a valid date.
