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.
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.
Add 3 Months to a Date
And in the same way, you want to add three days.
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.
- 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