Add/Subtract Years/Months/Days/Weeks to Date in Excel Office 365!!
Tags: addsubtractyearsmont, kutoolsexceltutorial, kutools
Published: 2020-10-01 12:27:18

---
title: Add/Subtract Years/Months/Days/Weeks to Date in Excel Office 365!!
published: true
date: 2020-10-01 12:26:09 UTC
tags: AddSubtractYearsMont,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/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](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) 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.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-data.png)<figcaption id="caption-attachment-14910">Example data</figcaption>

- 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.

![Select Formula Helper option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Formula-Helper-option.png)<figcaption id="caption-attachment-14911">Select Formula Helper option</figcaption>

- 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.

![Formula Helper dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Formula-Helper-dialog-box.png)<figcaption id="caption-attachment-14912">Formula Helper dialog box</figcaption>

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

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result.png)<figcaption id="caption-attachment-14913">Result</figcaption>

### 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.

![Example dates](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1.png)<figcaption id="caption-attachment-14914">Example dates</figcaption>

- 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.

![Select Add months to date option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Add-months-to-date-option.png)<figcaption id="caption-attachment-14915">Select Add months to date option</figcaption>

- 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.

![Formula Helper dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2.png)<figcaption id="caption-attachment-14916">Formula Helper dialog box</figcaption>

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

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3.png)<figcaption id="caption-attachment-14917">Output</figcaption>

### 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.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/4.png)<figcaption id="caption-attachment-14918">Example data</figcaption>

- 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.

![Select Add days to date option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/5.png)<figcaption id="caption-attachment-14919">Select Add days to date option</figcaption>

- 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.

![Formula Helper dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/6.png)<figcaption id="caption-attachment-14920">Formula Helper dialog box</figcaption>

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

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/7.png)<figcaption id="caption-attachment-14921">Result</figcaption>

### 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.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example.png)<figcaption id="caption-attachment-14922">Example</figcaption>

- 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.

![Select Add weeks to date option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/8.png)<figcaption id="caption-attachment-14923">Select Add weeks to date option</figcaption>

- 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.

![Formula Helper dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/10.png)<figcaption id="caption-attachment-14925">Formula Helper dialog box</figcaption>

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

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/9-1.png)<figcaption id="caption-attachment-14926">Output</figcaption>

### 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.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Lookup a Value and Return a Different Cell From the Table in Excel!!](https://geekexcel.com/how-to-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!!](https://geekexcel.com/find-position-of-nth-occurrence-of-a-character-in-text-string-in-excel/)