EDATE

Description

Use this function to return a date that is the specified number of months before or after the specified date, while keeping the same day of the month. This is useful for calculating maturity dates or due dates that fall on the same day of the month as the date of issue.

Syntax

EDATE(start_date, months)

Inputs

This function has the following arguments:

Name	Required	Valid input
`start_date`	Yes	The date that the result is to be calculated from. This can be a cell reference, an integer date, or a date in the format DD/MM/YYYY or YYYY/MM/DD. A formula which results in one of these is also acceptable.
`months`	Yes	The number of months before or after `start_date`. A positive value months yields a future date; a negative value yields a past date. This can be a cell reference or an integer. A formula which results in either of these is also acceptable.

Examples

Sample data

A	B	EDATE result
February 1, 2018	56	10/1/2022
April 23, 2019	39	7/23/2022
July 4, 2000	15	10/4/2001
7/19/2003	-92	11/19/1995
12/23/2023	22	10/23/2025

Sample formulas

Formula	Description	Result
`=EDATE(A1,56)`	Adds 56 months to the date in cell A1	10/1/2022
`=EDATE(7/19/2003,-92)`	Adds -92 months to the supplied date of `7/19/2003`	11/19/1995

Notes

The Workiva platform stores dates as numbers so they can be used in calculations. By default, January 1, 1900 = 1.
EDATE returns an integer date, which must be formatted as a date.
If the supplied or referenced start_date is not a valid integer date or in the format "DD/MM/YYYY" or "YYYY/MM/DD", EDATE returns the #VALUE! error.
If start_date has a fractional time attached (that is, is not an integer), it is removed.
If months isn't an integer, it's truncated.
If months contains a decimal value, it will be removed.
Wildcards don't work with this function.

Tips

To calculate an end-of-month date, use the EOMONTH function.
The EDATE function will strip times from dates that include time (sometimes called a "datetime").
To preserve the time in a date, you can use a formula like this: =EDATE(start_date,months)+MOD(start_date,1)
The MOD function extracts the time from the date, and then adds it back in.

Related functions

DATE
DATEVALUE
DAY
DAYS
DAYS360
EDATE
EOMONTH
MONTH
NETWORKDAYS
NETWORKDAYS.INTL
WEEKDAY
WORKDAY
WORKDAY.INTL
YEAR
YEARFRAC

Workiva Support Center