# How to Add Years to a Date in Excel (3 Easy Ways)

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.

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

<< Go Back to Adding Days to Date | Calculate Dates | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Chinmoy Mondol

Chinmoy Mondol is a computer engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in C, C++, Python, JavaScript, HTML, SQL, MySQL, PostgreSQL, Microsoft Office, and VBA and goes beyond the basics. He holds a B.Sc. in Computer Science and Engineering from American International University-Bangladesh. He has transitioned into the role of a content developer. Beyond his work, find him immersed... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF