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:

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

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