EDATE
Description
Returns a date that is the specified number of months after or before the start
date.
Syntax
EDATE(
start_date
,
months
)
- start_date: The date to add or subtract months from. Workday recommends using a cell reference to specify the date instead of entering the date as text, to ensure reliable results.
- months: The number of months to add or subtract from the start_date.
Example
Formula | Result |
|---|---|
=EDATE("15-Dec-2016",5) | 5/15/2017 |
=EDATE("15-Dec-2016",-5) | 7/15/2016 |