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

Get FREE Advanced Excel Exercises with Solutions!

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.

3 Ways to Add Years to a Date in Excel


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.

Using Simple Arithmetic Operation to Add Years to a Date in Excel

  • 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.

Utilizing EDATE Function to Add Years to a Date in Excel

  • 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.

Combining Multiple Functions to Add Years to a Date in Excel

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


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Chinmoy Mondol
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo