Determining A Date Months Or Years In The Future

For example, to determine what date is 27 months from the date in cell B2, use the DATE function.


Simply add or subtract the number of years, months or days from the corresponding element of the DATE function.

Also, rather than typing it into the formula, you could use a reference to a cell containing the number you want to add (or subtract).