Chinmoy Mondol
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.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice it by yourself.
3 Easy Ways 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 add years to a date in Excel. To learn better, you can follow the steps below.
Step 1:
- 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.
Step 2:
- 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.
Step 3:
- 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 (3 Easy Methods)
2. Utilizing 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.
Step 1:
- 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.
Step 2:
- 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.
Step 3:
- 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 Effective Ways)
Similar Readings
- How to Minus Number of Days or a Date from Today in Excel
- Excel Formula to Find Date or Days for Next Month (6 Quick Ways)
- How to Apply Excel Formula to Count Days from Date to Today
- Excel Formula to Calculate Number of Days Between Today and Another Date
- How to Add Weeks to a Date in Excel (4 Simple Methods)
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 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.
Step 1:
- Firstly, choose the D7 cell.
- Secondly, type the following formula below here.
=DATE(YEAR(C7)+$C$4,MONTH(C7),DAY(C7))
- Here, it will add the entered years (In my case, 5 years) to the existing date by adding the number of years.
- 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) is 2023.
- =DATE(YEAR(C7)+$C$4,MONTH(C7),DAY(C7)): This whole function finally shows the result as 1/1/2023.
Step 2:
- 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.
Step 3:
- Lastly, in the D column, you can see the totals for the five years summed together with the joining date.
Read More: How to Add Days to Date Using Excel Formula (5 Easy Ways)
Conclusion
In this article, we’ve covered 3 ways to add years to a date in Excel. I sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, ExcelDemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.
Related Articles
- How to Calculate Overdue Days in Excel (4 Easy Ways)
- Calculate Working Days Excluding Sundays in Excel
- How to Calculate Number of Months Between Two Dates in Excel
- Add Days to a Date in Excel Excluding Weekends (4 Ways)
- How Do I Add 7 Days to a Date in Excel (5 Methods)
- Subtract Dates in Excel to Get Years (7 Simple Methods)
- How to Calculate Years Between Two Dates in Excel (2 Methods)
