hopperpax.blogg.se

Add a comma to the start date field (In my case, Cell D6).ĥ. Type EDATE into the search box or choose the EDATE function from the drop-down menu.Ĥ. Using EDATE function to add years to a date in excelģ. In such case, you might want to look into the alternative options. Note: This technique will add or remove the year indicated, however it may display some differences in the days/months because leap years have 366 days, and this method operates on days.

You can copy this formula and use it in other cells as well. 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. Now, multiply the amount of years you wish to add or remove by 365, then press the Enter button (in my example, =D6+(2*365)).

After the cell reference, add an addition (+, for adding years) or subtraction (-, for deleting years) operator (in my example, Addition +).ĥ. You may also manually input the mobile phone number.Ĥ. Choose the cell with the current date (In my case, Cell D6). You should be able to type formulae using it.ģ. Choose the cell where you wish the output to appear (In my case, cell E6).Ģ. Using simple arithmatic operations to add years to a date in excel onlin, 20ġ. I've shown you three different ways to add or subtract years from an existing date in WPS spreadsheet in this article. It entails duties such as adding and subtracting days, months, and years from dates. Working with date-type data is a prerequisite in WPS spreadsheet.