Add Month to a Date

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:

1. First, enter “=EDATE(“ in cell B1.
2. After that, refer to cell A1, where you have the date.
3. Now, in the second argument, enter 1.
4. 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.

🔙 Excel Formulas