» Adding a Specified Number of Months to a Date
Column B contains numbers of months which are to be added to the corresponding dates shown in column A.
We want to calculate the appropriate cumulative dates.
Use the DATE, YEAR, MONTH, MIN, and DAY functions as shown in the following formula:
Use the EDATE function as shown in the following formula: