Sometimes, it’s essential to include dates in an Excel dataset for ease of use. You may need to add certain years to the date. There are several functions to do this operation. Also, you can follow a simple arithmetic formula to add years to the date. You can use any formula of your choice. In this article, we are going to show you some methods to add 2 years to a date in Excel. Let’s get started.
How to Add 2 Years to a Date in Excel: 3 Suitable Methods
You have to make a dataset first to add years to the date. We have taken a dataset of Students’ Admission Dates. Now, we want to append 2 years to these dates.
Not to mention, we have used the Microsoft 365 version. You may use any other version at your convenience.
1. Utilizing Arithmetic Formula
A year consists of 365 days we all know that. If you add 2*365 days to the date, then it will show exactly 730 days after the following dates. Follow the steps.
📌 Steps:
- Firstly, go to the D5 cell and enter the following formula.
It adds 2 years to the existing date.
- Subsequently, press ENTER and drag down the Fill Handle tool for the other cells.
You will eventually get the result shown in the image below.
But there is a significant issue with this method. You know that a leap year consists of 366 days. So, when you add 365 days, it shows you the day before the existing day if there is a leap year. In such a situation, it is better to utilize the following two methods.
Read More: How to Add 3 Months to a Date in Excel
2. Using the EDATE Function
The EDATE function provides a date according to the months number given in the argument. The entered number of months has been added to the existing value and returned as a result. Go through the following steps for better visualization.
📌 Steps:
- Initially, move to cell D5 and insert the formula.
It takes 24 months, as we entered the end_date argument as (2*12) with the start_date of the C5 cell.
Finally, you get the result shown in the above image after pressing ENTER.
Similar Readings
- How to Add Days to a Date in Excel Excluding Weekends
- How to Create a Formula in Excel to Change Date by 1 Year
- How to Add 3 Years to a Date in Excel
3. Applying the Nested DATE Function
You can use the nested DATE function to add 2 years to the date. In that case, you need to combine the YEAR, MONTH, and DAY functions to show the date. However, when we insert the YEAR function, we add two years because we want to. Follow the below steps.
📌 Steps:
- Firstly, go to cell D5 and enter the formula.
Formula Explanation:
- DAY(C5) syntax takes the day number of cell C5.
- MONTH(C5) syntax provides the month number of cell C5.
- YEAR(C5)+2 syntax adds 2 years with the existing year in cell C5.
- Finally, the DATE(YEAR(C5)+2, MONTH(C5), DAY(C5)) syntax returns the date where the years are changed with 2 years.
Eventually, press ENTER, and drag it down.
Finally, you get the outcome depicted in the image below.
Similarly, you can also add 3 years to the existing date. Here, we enter the end_date argument (3*12). The procedure is identical to Method 2. See the below image. Here, you can see 3 years have been added to the existing dates.
The formula we used here,
Read More: How to Add Years to a Date in Excel
How to Add Days to a Date in Excel
You can add days to your date using Method 3. The only extra task is that you have to add the number of days with the DAY function. We entered the following formula.
The basic difference is that the YEAR function here will remain unchanged, but we have added 15 with the DAY function, which will add 15 days to the existing value. See the image to get a proper idea.
Read More: How to Add 6 Months to a Date in Excel
How to Add Months to a Date in Excel
Yet again, we follow the same formula in Method 3. But you have to add the number of months with the MONTH function that you want to add. So, the formula for the D5 will be-
Here, we enter 6 with the MONTH function, which will add 6 months to the existing value. Look at the below image and observe the results carefully.
Read More: How to Add Months to a Date in Excel
Practice Section
We have provided a practice section on each sheet on the right side for your practice. Please do it yourself.
Download Practice Workbook
Download the following practice workbook. It will help you to realize the topic more clearly.
Conclusion
That’s all about today’s session. And these are some easy methods to add 2 years to a date in Excel. Please let us know in the comments section if you have any questions or suggestions. For a better understanding, please download the practice sheet. Thanks for your patience in reading this article.
Mr. Fahim. This article is quite helpful to me. It will be more helpful if you can enlighten me to show the day in text of your given date column. Then i can find out which day it was on that specific date.
Thanks in advance.
Hello, Mrs. Thomas. Thanks for your feedback. You can easily show the day in the text by using the TEXT function. Follow the steps for better visualization.
Firstly, go to cell E5 and insert the method.
=TEXT(D5,"dddd")It will make the day in full form of the text.
Then press ENTER and drag it down for other cells with the Fill Handle tool.
Finally, you got your result.
For displaying the month in text go to the cell F5 and write up the formula.
=TEXT(D5,"mmmm")Drag down it and get the full result for the dates.