Owner manual

“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.