Table of Contents
To add years to a date in Excel, you can use the EDATE function. This function adds a given number of months to a date and returns the result as a date. You can use EDATE to add years to a date by multiplying the number of years to add by 12 and then using that as the number of months argument. For example, to add 5 years to a date, you would enter =EDATE(date, 5*12). This will return the date that is 5 years and 5*12 months after the date entered.
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.