Home ➜ Excel Formulas ➜ **Add Years to Date**

Let’s say you have a date, and in that, you want to add a year to the get same date for the next year. In this tutorial, we will look at some of the examples to create a formula for this.

## Add a 3 Years in a Date in Excel

Here we are using the date 1-Jan-2021 to make it more understandable to you, and you need to add three years to this date, so the date would be 1-Jan-2024. For this, we will use the EDATE function.

- First, you need to EDATE function in cell B1.
- After that, in the first argument, refer to cell A1.
- Next, 12 for specifying 12 months.
- Now, multiply 12 with 3 to specify 3 years.
- In the end, enter the closing parentheses and hit enter.

=EDATE(A1,12*3)

## Add 5 Years in a Date

Now in the same way, if you want to add 5 years to the date the formula would be something like this.

=EDATE(A1,12*5)

## Subtract 10 Years from a Date

And if you want to subtract a year, let’s say ten years, you can use a formula just like below.

## Other Method to Add and Subtract Years from a Date

You can also use a combination of (Date, Year, Month, and Day) functions to add or subtract years from a date.

In this formula:

- The year function gets the year from the date,
- The month function takes a month from the date and then adds five years (60 months) to it.
- The day function takes a day from the date.
- And the date function, in the end, creates a new date using input from all the functions.

=DATE(YEAR(A1),(MONTH(A1)+(12*5)),DAY(A1))

You can also use the same formula to subtract the years from a date.

=DATE(YEAR(A1),(MONTH(A1)+(-12*5)),DAY(A1))

🔙 **Excel Formulas** \ 📂 **sample-file**

## More Formulas

- Add Month to a Date
- Add-Subtract Week from a Date
- Calculate Age using Date of Birth
- Compare Two Dates
- Convert Date to Number
- Count Years Between Two Dates
- Create a Date Range
- DATEDIF Function in Excel
- Get Day Number of Year
- Get Month from a Date
- Get Quarter from a Date [Fiscal + Calendar]
- Get Years of Service
- Get Day Name from a Date in Excel
- Get End of the Month Date in Excel
- Get Total Days in Month in Excel
- Highlight Dates Between Two Dates
- Quickly Concatenate Two Dates
- Random Date Generator (Excel Formula)
- 5 Custom Date Formats I Always Use and You Should Too
- Convert Text to Date
- Get First Day (Beginning) of the Month