Add/Subtract Years/Months/Days/Weeks to Date in Excel Office 365!!

Add/Subtract Years/Months/Days/Weeks to Date in Excel:

In this article, we are going to see how to Add/Subtract Years/Months/Days/Weeks to Date in Excel Office 365 using Kutools with examples. Let’s get into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Note: kutools for Excel has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

*Steps to Add Number of Years to Date or Subtract Years from Date: *

Let’s see the steps to add the number of years to date or subtract years from a date with the help of Kutools.

• In the following image, you can see the example date list. We are going to add or subtract the number of years from each date on that list.

• You need to select a cell where you want to display the result.
• Then, go to the Kutools Tab, select the Formula Helper option, choose the Add years to date option from the menu.

• It will open the *Formula Helper dialog box. *
• In that dialog box, select the Add years to date option from Choose a Formula box.
• You need to select a date cell to which you want to add years using the button given in the Date time input box.
• In the Number box, you need to *enter the number of years * that you want to add to the selected date.
• Click the OK button.

• Now, you can get the result in the selected cell. Then, you need to drag it down to fill the remaining cells.

Note:

• If you want to subtract the number of years from date, you need to give the negative number ( For example, -3 , -5, -8) in the Number text box in the Formula Helper dialog box.

Add Number of Months to Date or Subtract Months from Date:

To add or subtract the number of months to date, do as follows.

• In the following image, you can see the example date list. We are going to add or subtract the number of months from each date on that list.

• You need to select a cell where you want to display the result.
• Then, go to the Kutools Tab, select the Formula Helper option, choose the Add months to date option under the Date & Time option.

• It will open the *Formula Helper dialog box. *
• In that dialog box, select the Add months to date option from Choose a Formula box.
• You need to select a date cell to which you want to add months using the button given in the Date time input box.
• In the Number box, you need to enter the number of months that you want to add to the selected date.
• Hit the OK button.

• Now, you can get the result in the selected cell. Then, you need to drag it down to fill the remaining cells.

Note:

• If you want to subtract the number of months from the date, you need to give the negative number (For example, -30 ,-8) in the Number text box in the Formula Helper dialog box.

Steps to Add Number of Days to Date or Subtract Days from Date:

Here are the instructions to add the number of days to date or subtract days from the date using Kutools.

• In this screenshot, you can see the example date list. We are going to add or subtract the number of months from each date on that list.

• You need to select a cell where you want to display the result.
• Then, go to the Kutools Tab, select the Formula Helper option, choose the Add days to date option under the Date & Time option.

• It will open the *Formula Helper dialog box. *
• In that dialog box, select the Add days to date option from Choose a Formula box.
• You need to select a date cell to which you want to add days using the button given in the Date time input box.
• In the Number box, you need to enter the number of days that you want to add to the selected date.
• Hit the OK button.

• Now, you can get the result in the selected cell. Then, you need to drag it down to fill the remaining cells.

Note:

• If you want to subtract the number of days from the date, you need to give the negative number (For example, -23 , -15) in the Number text box in the Formula Helper dialog box.

Add Number of Weeks to Date or Subtract Weeks from Date:

To add the number of weeks to date or subtract weeks from date, do as follows.

• In the below-given screenshot, you can see the example date list. We are going to add or subtract the number of months from each date on that list.

• You need to select a cell where you want to display the result.
• Then, go to the Kutools Tab, select the Formula Helper option, choose the Add weeks to date option under the Date & Time option.

• It will open the *Formula Helper dialog box. *
• In that dialog box, select the Add weeks to date option from Choose a Formula box.
• You need to select a date cell to which you want to add weeks using the button given in the Date time input box.
• In the Number box, you need to enter the number of weeks that you want to add to the selected date.
• Hit the OK button.

• Now, you can get the result in the selected cell. Then, you need to drag it down to fill the remaining cells.

Note:

• If you want to subtract the number of weeks from the date, you need to give the negative number (For example, -13 , -5) in the Number text box in the Formula Helper dialog box.

Closure:

In the above article, you can clearly understand the steps to Add/Subtract Years/Months/Days/Weeks to Date in Excel Office 365 using Kutools with examples. Drop your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!

Read Also:

• Lookup a Value and Return a Different Cell From the Table in Excel!!
• Find Position of Nth Occurrence of a Character in Text String in Excel!!