Excel Formulas to Add or Subtract the Month to the Given Date!!
Tags: excelformula, excelformulas
Published: 2021-04-28 11:34:18

---
title: Excel Formulas to Add or Subtract the Month to the Given Date!!
published: true
date: 2021-04-27 11:53:16 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-add-month-to-date/
---

We have already learned how to **[add or subtract the days from the current date](https://geekexcel.com/excel-formulas-to-add-or-subtract-days-from-the-given-date/)**. Likewise, here we are going to learn the simple formula to **add or subtract the month from the given date in Excel.** 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)

[![Add months to the given date](https://geekexcel.com/wp-content/uploads/2021/04/Add-months-to-the-given-date.png)](https://geekexcel.com/excel-formulas-to-add-month-to-date/add-months-to-the-given-date/#main)<figcaption id="caption-attachment-34846">Add months to the given date</figcaption>

## General Formula:

- You can use the below formula to add a number of months to a date in Excel.

**=[EDATE](https://geekexcel.com/how-to-use-edate-function-in-excel-365/)(date,months)**

## Syntax Explanations:

- **EDATE** – The[** EDATE Function**  ](https://geekexcel.com/how-to-use-edate-function-in-excel-365/)adds or subtracts the specified number of months with the given date and returns the serial number that represents the result date in Excel.
- **Date**  – It specifies the input dates.
- **Months** – It represents the number of months that want to add or subtract from the input date.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

Refer to the below example image.

- First, we will enter the input dates in **Column B**.
- Now we are going to add or subtract the number of months given in ** Column C**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-35.png)<figcaption id="caption-attachment-34848">Input Ranges</figcaption>

- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the  **ENTER**  key.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/04/Enter-the-formula-27.png)<figcaption id="caption-attachment-34847">Enter the formula</figcaption>

- Finally, we will get the result in the selected cell.

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result-36.png)<figcaption id="caption-attachment-34849">Result</figcaption>

## Conclusion:

So yeah guys this is how we can **add or subtract the month from the given date in Excel**. I hope you like this article. If you have any doubts, don’t forget to share them with us. Thank you so much for visiting our site. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Round Number Down to Nearest Multiple Value!!](https://geekexcel.com/excel-formulas-to-round-number-down-to-nearest-multiple-value/)**
- **[How to Protect All Cells with Formulas using Macros in Excel 365?](https://geekexcel.com/how-to-protect-all-cells-with-formulas-using-macros-in-excel-365/)**
- **[Excel Formulas to Add Decimal Hours to the Time ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-add-decimal-hours-to-the-time/)**