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.
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.
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.
You can also use the same formula to subtract the years from a date.
- 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