How to Add Years to Date in Excel (With Examples)


You can use the following basic syntax to add years to a date in Excel:

=DATE(YEAR(A2)+3,MONTH(A2),DAY(A2))

This particular formula adds 3 years to the date in cell A2.

To add a different number of years, simply change the 3 in the formula to a different number.

And to subtract a certain number of years from a date, simply use a negative number instead of a positive number in the formula.

The following example shows how to use this syntax in practice.

Example: Add Years to Date in Excel

Suppose we have the following list of dates in Excel:

We can type the following formula into cell B2 to add 3 years to the date in cell A2:

=DATE(YEAR(A2)+3,MONTH(A2),DAY(A2))

We can then drag and fill this formula down to each remaining cell in column B:

Excel add years to date

Notice that each of the values in column B show the value of the date in column A plus three years.

To add a different number of years, simply change the 3 in the formula to a different number.

For example, we can use the following formula to instead add 10 years to each date:

=DATE(YEAR(A2)+10,MONTH(A2),DAY(A2))

Now each of the values in column B shows the value of the date in column A plus 10 years.

We can also use a negative value in the formula to subtract years.

For example, we can use the following formula to instead subtract 10 years to each date:

=DATE(YEAR(A2)-10,MONTH(A2),DAY(A2))

Excel subtract years from date

Now each of the values in column B shows the value of the date in column A minus 10 years.

Note: We wrap the DATE function around the formula to ensure that the result is shown in a date format instead of a numeric format.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Convert Days to Months in Excel
How to Calculate Average by Month in Excel
How to Calculate the Number of Months Between Dates in Excel

Leave a Reply

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