Excel is the first but already old sort of spreadsheet working tool that answers most obligatory requirements. Here are several ways to enter data to insert into cells inside an Excel spreadsheet, and sometimes the data may contain few date columns. The great thing is that Excel does have some predefined functions relating to data, and therefore if you want to add years to date in Excel, it is going to be significantly easier.
Because everyone has different needs and numerous data formulae apply to this goal, we have divided this article into several parts. Two of the most effective ways to do this is by:
1. Calculating simple addition, subtraction, multiplication, division, or any other form of computation. The formula for performing an arithmetic operation to add one year in date in cell A1 is:
=A1+(1*365)
2. Date function (It is useful when one wishes to type a different section of date as a substitute for days added.) The formula for using the date function to add one year in date in cell A1 is:
Date Year of date value in cell A1 plus 1, the month of which is contained in cell A1 and the day of which is contained in cell A1.
Here is the information that you ought to provide to make the change of the data in the Excel spreadsheet much easier.
How to Add a Year to A Date in Excel?
The simplest way by which one can use in adding a year to any date data in an Excel spreadsheet is the use of the arithmetic operation method. This method involves a basic form of operation of integrating 365 days into the date you have keyed in. That is because we apply the addition operation on the date format we use and, as a result of adding 365 days one year advances in the date. As for the meanings of the symbols: 1 gives the number of years we want to add, it’s multiplied by 365.
- Right-click on it and, or, click on any cell of your choice to insert the updated date.
- On the top go to the formula bar and type in the formula “=E2+(1*365)” You will put E2 with the cell that originally has a date in your case. I will now click anywhere, and a new date will come up.
How to Add 2 Years to a Date in Excel?
February 28 of any year plus 2 years is like February 28 of exactly one year added. The best method is the arithmetic operation method since typing the formula is easier as compared to tracking the various cells. That being said here is how you can implement it: Implementing this formula is not as difficult since you already understand how it operates in the following ways.
- It will open up a drop-down box to select the updated date Click the cell where you want the updated date to go. Clicking will select the above cell and you can go for the next step if need be.
- In the formula bar of the cell at the top, enter the formula as =E2+(2*365) Don’t forget that E2 should be replaced with the particular cell number. After typing this, you simply press the enter key on the keyboard, and the new date C1 value will appear.
How to add 3 years to a date in Excel?
Although the same method of arithmetic operation can also be applied here let me use another method. It is also important to know that in this method, you will be creating value from the perspective of the year only. Therefore even if there’s a leap year between the old date and the updated date it will not be counted since we keep on putting preferably the day and the month.
The method is known as the date function method, and it works by adding a specific number to the given date data with the following steps:
- Again, we will HDC on the target cell and then look at the facility bar on the top.
- The fourth cell should contain a formula for getting the current date three months later which is to write “=DATE(YEAR(E10)+3, MONTH(E10), DAY(E10))”. In this case, the original data is present in cell E10 as is shown in the following figure. You have to plug in E10 with the cell that contains this date for your case. Now go ahead and click on some other cell to see what the value is now.
How to Add 5 Years to a Date in Excel?
Subtracting 5 years in the date is not different than any of the other methods discussed above. Therefore, you can employ any of the two techniques mentioned above and get the best results. But in our case, we will stick with the date function method. We mentioned in the previous part that you add 3 to the year value in the formula. This formula allows us to add any number, and, in this part, we will add 5 in the steps below:
- Choose the cell in that row of the target table that needs the updated date value to be inserted.
- Move to the formula bar on the top and enter the formula like this: =DATE(YEAR(E10)+5, MONTH(E10), DAY(E10)) Before that remember to substitute E10 as your original date value cell name. Press enter to get the new value of the cell that appears in the previous cell that was selected.
How to Add 60 Years to a Date in Excel?
Tell them that you would wish to add a bigger number to the year. However, if you are not so concerned with your output you can use the date function method as it is efficient for addition several years. This method just puts an addition to the years without changing the days and months. So, here is how you can do it:
- In the beginning, click on an empty cell to set the target date which needs to be updated.
- Go to the formula bar up and type the formula as =DATE(YEAR(E10)+60, MONTH(E10), DAY(E10)). When the formula is applied, you ensure that the data is updated with the addition of thirteen zeroes, and the years are added to 60.
How to Add 100 Years to a Date in Excel?
Since the earlier described technique of how to add more years to a cate inside an Excel spreadsheet is easier and faster by using the date function method, we will be using this as well. The process will be like the previous parts with the following steps:
- Choose your target updated date cell by left-clicking on it. Now press the formula bar under the menu bar in Excel.
- In the formula bar what you type is the formula as it is which is ” =DATE(YEAR(E10)+100,MONTH(E10),DAY(E10))”. Now when pressing enter it will change the date value in the target cell.
How to Add Years, Months, and Days to a Date in Excel?
Say that you wish to append particular or all these time measures to date at once. The date function also lets you do that you know. In the previous part, we only increased a numeral to the year. Similarly, the same work with the month and day values will also enable us to update the day and date. Here are the steps and formula that you must follow to get it done:
- Make a decision choosing a cell on an excel sheet as the target cell. That cell will go to an updated date.
- Get to the formula bar and then type in the following formula =DATE(YEAR(E10)+3, MONTH(E10)+2, DAY(E10)+1). Press the enter key or click any other cell to see the updated date which contains all changes you have made to this formula.
As we know in this example we have added 1 today which made it 2, similarly adding 2 to January took it as March in the same way by adding 3 to 2001 we had taken it as 2004.
