Returns a date a specified number of months before or after a given date.
Sample Usage
EDATE(DATE(2019,7,20),1)
EDATE(DATE(2019,7,20),-2)
EDATE(C5)
Syntax
EDATE(start_date, [months])
- start_date - The date from which to calculate the result.
- months - [OPTIONAL] The number of months before or after start_date.
Examples
EDATE(DATE(2019,7,20),1) returns the date, one month after the given date.
EDATE(DATE(2019,7,20),-2) returns the date, two months before the given date.
Notes
- EDATE does not auto-convert number formats. Therefore, EDATE(10/10/2000) is interpreted as EDATE(0.05) , the quotient of 10 divided by 10 divided by 2000.
- Problems can occur if dates are entered as text. You can use the DATE function to enter a date. For example, use DATE(2020,2,3) for the 3rd day of January, 2020.
- You can also use other functions which return a date object. (For example: DATEVALUE).
- Decimal inputs will be truncated.