Home ➜ Excel Formulas ➜ **Add Month to a Date**

Just like years, you can add months in a date to get a future date and subtract to get a date from the past. In this tutorial, we will look at all the methods with multiple examples to do that.

## Get Next Month’s Date

In the first example, we will write a formula to get the date from the next month and we will use the EDATE formula. As you can see in the following example, we have a date in cell A1, for which we need to get the exact date for the next month.

Follow the below steps:

- First, enter “=EDATE(“ in cell B1.
- After that, refer to cell A1, where you have the date.
- Now, in the second argument, enter 1.
- In the end, type a closing parenthesis and hit enter.

Here you have the date 10-Feb-2022 in cell B1 which is exactly 1 month ahead (next month) from the date we have specified in the formula.

=EDATE(A1,1)

## Add 6 Months to a Date

In the same way, you can add 6 months to a date and get a date that is 6 months ahead of the current date. In the following example, we have the same date in cell A1 that we had earlier.

Now to add 6 months to this you just need to use the following formula.

=EDATE(A1,6)

## Add 3 Months to a Date

And in the same way, you want to add three days.

=EDATE(A1,3)

## Subtract Months from a Date

Now let’s say you want to subtract months from a date. In this case, you just need to use a negative number in the second argument (month).

In the following example, we have used -6 in the month argument, and we have the date 10-Jul-21 which is exactly 6 months back from 10-Jan-22.

## More Formulas

- Add Years to Date
- Add-Subtract Week from a Date
- Calculate Age using Date of Birth
- Compare Two Dates
- Convert Date to Number
- Count Years Between Two Dates
- Create a Date Range
- DATEDIF Function in Excel
- Get Day Number of Year
- Get Month from a Date
- Get Quarter from a Date [Fiscal + Calendar]
- Get Years of Service
- Get Day Name from a Date in Excel
- Get End of the Month Date in Excel
- Get Total Days in Month in Excel
- Highlight Dates Between Two Dates
- Quickly Concatenate Two Dates
- Random Date Generator (Excel Formula)
- 5 Custom Date Formats I Always Use and You Should Too
- Convert Text to Date
- Get First Day (Beginning) of the Month