# EDATE Function: The easiest way to add or subtract months to your dates!

We deal with a lot of Date variables in Excel and to support that, Excel has a vast variety of formulas which work with Dates. When it comes to adding or subtracting certain months from any given date, the Excel formula to use is EDATE.

The syntax for EDATE function is:

=EDATE(start_date,months)

• start_date – It is the date to which you want to add months
• months – it is the number of months you would like to add or subtract to the start_date. Use a positive integer to add months and a negative integer to subtract months

## Example 1: Adding months to any given Date

Now that we know the syntax of EDATE formula. Let look at an example to understand how to use this formula to add months to a date

1. Create a table as shown below. Let’s say this represents the various dates to which we need to add the number of months mentioned in the Months column
2. Now to add the Months to the Date, we write the formula =EDATE(A2,B2) in cell C2 as shown below
3. You’ll notice that the result of the above formula will be a serial number. Drag the formula till C11 to get the results as shown below
4. You can change the number format of the cells to Date to represent the date in the correct format
5. When formatted in the dd-mmm-yy format, the results are as shown below
6. This is how we can add months to any date using the EDATE formula.

## Example 2: Subtracting Months from a given date

Since we saw an example where we added months to any given date, now we’ll look at an example where we subtract months from any date

1. Create a table as shown below. Let’s say this represents the various dates from which we need to subtract the number of months mentioned in the Months column
2. No to add the Months to the Date, we write the formula =EDATE(A2,B2) in cell C2 as shown below
3. You’ll notice that the result of the above formula will be a serial number. Drag the formula till C11 to get the results as shown below
4. You can change the number format of the cells to Date to represent the date in the correct format
5. When formatted in the dd-mmm-yy format, the results are as shown below
6. This is how we can subtract months to any date using the EDATE formula.

You can download and refer to the solution file from the link below:

Download the file here

You can also check my Excel Date and Time Masterclass Video Tutorial below, which explains Date and Time in Excel from Scratch!

Please share

Did you find this useful?  Why not share the love and tell your friends on the different social media platforms.

### Get our Excel Date & Time Functions Cheat sheet!

Enter your First Name & Email to get our Excel Date & Time functions cheat sheet and subscribe to our Newsletter!

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Latest posts by Abdelrahman Abdou (see all)
It's only fair to share...
Facebook
0
Pinterest
0
Twitter
Linkedin