Formulas and Functions

“YEARFRAC” on page 63
“Listing of Date and Time Functions” on page 42
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
EDATE
The EDATE function returns a date that is some number of months before or after a
given date.
EDATE(start-date, month-oset)
 start-date: The starting date. start-date is a date/time value.
 month-oset:The number of months before or after the starting date. month-oset
is a number value. A negative month-oset is used to specify a number of months
before the starting date and a positive month-oset is used to specify a number of
months after the starting date.
Examples
=EDATE(”1/15/2000”, 1) returns 2/15/2000, the date one month later.
=EDATE(”1/15/2000”, -24) returns 1/15/1998, the date 24 months earlier.
Related Topics
For related functions and additional information, see:
“EOMONTH” on page 51
“Listing of Date and Time Functions” on page 42
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
50 Chapter 3 Date and Time Functions