In MS Excel, working with date-type values is a necessary requirement. It involves tasks like adding days, months, or years to existing dates. In this article, we will demonstrate to you to add years to a date in Excel.
Here, we will show you to add years to a date in Excel by using a simple arithmetic operation, the EDATE function, and combining multiple functions such as the DATE function with the YEAR function, the MONTH function, and the DAY function. Let’s suppose we have a sample data set.
1. Using Simple Arithmetic Operation to Add Years to a Date in Excel
In this section, we will apply simple arithmetic operations. To learn better, you can follow the steps below.
- Firstly, select the D7 cell.
- Then, write down the following formula.
=C7+($C$4*365)
- Here, it will add the entered number of years (In my case, 2 years) to the existing date by adding the number of days to it.
- After that, hit ENTER.
- So, you will see the result of 2 years added with the first person joining date.
- Then, use the Fill Handle tool and drag it down from the D7 cell to the D11 cell.
- Finally, the given image displays all the 2 years added joining date in the D column.
Read More: How to Add 2 Years to a Date in Excel
2. Inserting Excel EDATE Function to Add Years to a Date
The EDATE function adds the entered number of months to the entered data and returns the value.
Syntax of the EDATE Function
=EDATE (start_date, months)
Arguments of the EDATE Function
Start_date: This argument represents the existing date-type value.
Months: This argument signifies the number of months to be added.
- Firstly, select the D7 cell.
- Then, write down the following formula below here.
=EDATE(C7,($C$4*12))
- Here, it will add the entered years (In my case, 5 years) to the existing date by creating a new date with the given values.
- After that, hit ENTER.
- Then, you will see the result of 5 years added with the first person joining date.
- After that, use the Fill Handle tool and drag it down from the D7 cell to the D11 cell.
- Lastly, you will see all the results of 5 years added with the joining date in the D column here.
Read More: How to Add 3 Years to a Date in Excel
3. Combining Multiple Functions to Add Years to a Date in Excel
There are a number of functions in Excel for altering date values, but the DATE function with the YEAR, MONTH, and DAY functions is by far the most versatile and straightforward. It constructs a valid date from the individual year, month, and day values.
Syntax of the DATE Function
=DATE (year, month, day)
Arguments of the DATE Function
Year: This argument represents the number of years for the date.
Month: This argument indicates the number of months for the date.
Day: This argument signifies the number of days for the date.
- Firstly, choose the D7 cell.
- Secondly, type the following formula below.
=DATE(YEAR(C7)+$C$4,MONTH(C7),DAY(C7))
- Then, press ENTER.
Formula Breakdown
- DAY(C7): This argument in the DATE function shows the number of days for the date and the value is 1.
- MONTH(C7): This argument in the DATE function finds the number of months for the date and it returns the value 1.
- YEAR(C7)+$C$4:This argument in the DATE function shows the number of years for the date and it returns the value by adding the value of C4 cell (5) as 2023.
- =DATE(YEAR(C7)+$C$4,MONTH(C7),DAY(C7)): This whole function finally shows the result as 1/1/2023.
- Therefore, you will see the result of 5 years added with the first person joining date.
- Besides, use the Fill Handle tool and drag it down from the D7 cell to the D11 cell.
- Lastly, in the D column, you can see the totals for the five years summed together with the joining date.
Read More: How to Create a Formula in Excel to Change Date by 1 Year
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice it by yourself.
Conclusion
In this article, we’ve covered 3 ways to add years to a date. I sincerely hope you enjoyed and learned a lot from this article. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.
Related Articles
- How Do I Add 7 Days to a Date in Excel
- How to Add 30 Days to a Date in Excel
- How to Add Days to a Date in Excel Excluding Weekends
- How to Add Weeks to a Date in Excel
- How to Add Months to Date in Excel
- How to Add 3 Months to a Date in Excel
- How to Add 6 Months to a Date in Excel
<< Go Back to Adding Days to Date | Calculate Dates | Date-Time in Excel | Learn Excel