Edate, Even – Apple Numbers '08 User Manual
Page 229
Chapter 12
Dictionary of Functions
229
EDATE
The EDATE function finds a new date some number of months before or after a given
date.
EDATE(date, month-offset)
 date: The starting date.
 month-offset: The number of months before or after date. The month-offset is
negative for a date earlier than date.
EVEN
The EVEN function rounds a number away from zero to the next even number.
EVEN(number)
 number: The number you want to round. It can be a number, a numeric expression,
or a reference to a cell containing a numeric expression.
Notes
To round to an odd number, use the ODD function.
Examples
DOLLAR(2323.124) returns $2,323.12.
DOLLAR(2323.125) returns $2,323.13.
DOLLAR(99.554, 0) returns $100.
DOLLAR(12, 3) returns $12.000.
DOLLAR(-12, 3) returns ($12.000), with parentheses indicating a negative amount.
DOLLAR(123, -1) returns $120.
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.
Examples
EVEN(1) returns 2.
EVEN(2) returns 2.
EVEN(2.5) returns 4.
EVEN(-2.5) returns -4.
EVEN(0) returns 0.