Mehedi Hasan Shimul
When we work with dates in Excel, sometimes we may want to add specific years to a date. It’s quite easy to do in Excel. At the same time, Excel offers several ways to add years to a date. In this article, I will show you 3 effective ways to add 3 years to a date in Excel. So, without any delay, let’s start the discussion.
Download Practice Workbook
You can download the practice workbook from here.
3 Effective Ways to Add 3 Years to a Date in Excel
We can add 3 years to a date following several methods in Excel. Here, I will discuss 3 effective ways to add 3 years to a date in Excel. For demonstration, I have introduced a dataset having Brand, and Founding Date. We add years in the Date after 3 Years column.
1. Insert EDATE Function to Add 3 Years to a Date in Excel
The addition of 3 years to a date can be done by using the EDATE function of Excel. I am showing the stepwise procedures for the method in the following.
- First, select Cell D5 and write the following formula there.
=EDATE(C5,3*12)- Then, press Enter.
- Instantly, we will see the date after 3 years in Cell D5.
- Further, use the Fill Handle to copy the formula in the cells below.
In the formula,
- The EDATE function takes the date from Cell C5 and adds 3*12 months to the date.
- As a consequence, we will see all the dates after 3Â years.
Read More: How to Add Years to a Date in Excel (3 Easy Ways)
2. Utilize DATE, YEAR, MONTH & DAY Functions Together to Add 3 Years to a Date
We can use the DATE, YEAR, MONTH, and DAY functions altogether to add 3 years to a date. I am showing the stepwise procedure to do that in the below section.
2.1 Adding 3 with YEAR Function
We can add 3 to the first argument of the DATE function which is the year. Follow the steps given below for the procedures.
- First, write the following formula in Cell D5.
=DATE(YEAR(C5)+3,MONTH(C5),DAY(C5))- After that, hit Enter.
- Finally, use the Fill Handle to copy the formula in the cells below.
- Instantly, we will see 3 years added to all the dates.
In the formula,
- The YEAR function takes the year value from the date of Cell C5 and we added 3 with it.
- The MONTH and DAY functions get the month and day value from the date of Cell C5.
- The DATE function takes the arguments and gives the output date.
 2.2 Adding 3*12 with MONTH Function
Instead of adding 3 with the YEAR function, we can add 3*12 with the MONTH function to get the same result. Let’s walk through the procedures.
- First, write the following formula in Cell D5.
=DATE(YEAR(C5),MONTH(C5)+3*12,DAY(C5))- Next, press Enter.
- Further, use the Fill Handle to copy the formula in the cells below.
- Simultaneously, we will see all the dates after 3Â years.
In the formula,
- The MONTH function takes the month value from the date of Cell C5 and we added 3*12 with it.
- The YEAR and DAY functions get the year and day value from the date of Cell C5.
- The DATE function takes the arguments and gives the output date.
Read More: How to Add 2 Years to a Date in Excel (3 Easy Methods)
Similar Readings
- How to Count Months in Excel (5 ways)
- How to Add 7 Days to a Date in Excel (3 Methods)
- Excel Formula to Find Date or Days for Next Month (6 Quick Ways)
- How to Add Dates in Excel Automatically (2 Simple Steps)
- How to Create a Day Countdown in Excel (2 Examples)
3. Apply Simple Formula to Add 3 Years to a Date
In addition to the previous methods, we can use a more simplified formula to add 3 years to a date. I am discussing the stepwise procedures below.
- Firstly, write the following formula in Cell D5.
=C5+3*365- Then, hit Enter.
- Afterward, use the Fill Handle to copy the formula in the following cells.
- Finally, we will see the dates after 3 years in each cell.
In the formula,
- We have added 3*365 days with the date from Cell C5 to get the date after 3Â years.
Read More: How to Apply Excel Formula to Count Days from Date to Today
How to Add 3 Months to a Date in Excel
The addition of 3 months to a date is quite similar to the addition of 3 years to a date. We can easily do that using the EDATE function of Excel. Let’s follow the stepwise procedures.
- Firstly, write the following formula in Cell D5.
=EDATE(C5,3)- Next, hit Enter.
- Also, use the Fill Handle to copy the formula in the following cells.
- Finally, we will see the dates after 3 years in each cell.
In the formula,
- We have used the EDATE function which adds 3 months (as 3 is in the argument) to the date from Cell C5.
Read More: How to Add 6 Months to a Date in Excel (2 Easy Ways)
Conclusion
Adding 3 years to a date is quite a simple task in Excel. Here, I have discussed 3 effective ways to add 3 years to a date in Excel. Please, leave a comment if you have any queries or suggestions. Visit our ExcelDemy Website for similar articles regarding Excel.
Related Articles
- How to Add Weeks to a Date in Excel (4 Simple Methods)
- How to Calculate Age on a Specific Date with Formula in Excel
- Excel Formula for Number of Days Between Two Dates
- How to Minus Number of Days or a Date from Today in Excel
- How to Add Days to a Date in Excel Excluding Weekends (4 Ways)
- Excel Formula to Count Days from Date (5 Easy Methods)
