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.
Download Practice Workbook
Download the following practice workbook. It will help you to realize the topic more clearly.
3 Methods to Add 2/3 Years to a Date in Excel
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.
- 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.
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.
- 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.
- How to Minus Number of Days or a Date from Today in Excel
- Calculate Overdue Days in Excel (4 Easy Ways)
- How to Count Date Occurrences in Excel (3 Suitable Examples)
- Add Days to a Date in Excel Excluding Weekends (4 Ways)
- How to Create a Day Countdown in Excel (2 Examples)
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.
- Firstly, go to cell D5 and enter the formula.
- 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,
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.
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.
We have provided a practice section on each sheet on the right side for your practice. Please do it yourself.
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. Visit our website, Exceldemy, a one-stop Excel solution provider, to find out about diverse kinds of Excel methods. Thanks for your patience in reading this article.
- How to Calculate Days Outstanding in Excel (With Easy Steps)
- How to Use DateDiff Function in Excel VBA (5 Examples)
- Calculate Number of Days between Two Dates with VBA in Excel
- How to Calculate Years in Excel from Today (4 Ways)
- How to Calculate Age on a Specific Date with Formula in Excel
- Excel Formula to Calculate Number of Days Between Today and Another Date