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.

=DATE(YEAR(B2),MONTH(B2)+27, DAY(B2))


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).

Leave a Reply

Your email address will not be published. Required fields are marked *