Edate, Even – Apple Numbers '08 User Manual

Page 229

Advertising
background image

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.

Advertising