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 we will use the EDATE formula. As you can see in the following example, we have a date in cell A1, for which 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 exact 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 have 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 got the date 10-Jul-21 which is exact 6 months back from the 10-Jan-22.