The EDATE function returns the date which is the number of months after or before from the date which you specify.

For example, if you specify date 01-Apr-2016 and 5 as a month number, it will return 1-Sep-2016 in the result as September is exactly 5 months after April.

You can use EDATE while calculating maturity dates and for defining deadlines for tasks.

## Syntax

EDATE(start_date,months)

*start_date**A date from which you want to start.***months**Number of months after & before you want to calculate.

## Examples

Below we have used EDATE with different types of arguments.

- In the first example, we have used 5 as numbers of months and it has added exactly 5 months in 1-Jan-2016 and returned 01-June-2016.
- In the second example, we have used -1 months and it has given 31-Dec-2016, a date which is exactly 1 month back from 31-jan-2016.
- In the third example, we have inserted a date directly into the function.

## Remember

- Excel store dates as serial numbers, so start date should be a valid date.
- And, if the start date is not a valid date, it will return #VALUE! error.
- Use a positive number in “months” to get a future date and a negative number for a past date.

**Note: **EDATE is quite smart to give you the same date in future and past. It doesn’t matter that there are 31 days, 30 days or 28 days in a month.

## Sample File

Download sample file from here to learn more.

*This function is from the **list of top 100 functions with examples** and from here you can also learn some **useful formulas**.*

Related Functions

- DATEVALUE Function: It converts a textual date into a date according to Excel's date format. You can refer to a cell [...]
- DATEDIF Function: It returns the difference between the start date and end date using six different ways [...]
- DATE Function: It returns a date serial number as per Excel's date system when you provide [...]

Related Tips

- Calculate Age in Excel: This formula is the most simple and easiest way to calculate a person's age using his/her date of birth [...]
- End of the Month Date: Sometimes we need to get an end of the month date to use as a completion date, due date [...]
- Text to Date: These are the 10+ examples which you can use to correct textual date into an actual dates [...]

Robert from Sheetgo16 May, 17 at 4:31 pmDoes Google Sheets support edate as well?

Jonatan Silva21 Jun, 17 at 9:45 pmHi Robert,

I was looking for and found this tutorial:

https://www.sheetgo.com/edate-formula-google-sheets/

Best,

Robert from Sheetgo23 Jun, 17 at 7:53 amThanks, Jonatan!

Ogundepo Ezekiel Adebayo15 Mar, 17 at 7:14 pmThank you. I’ve not heard of emonth before in excel.