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.
- Numbers '09 (254 pages)
- Keynote '09 (247 pages)
- Pages '09 (279 pages)
- Boot Camp Mac OS X v10.6 Snow Leopard (18 pages)
- Boot Camp Mac OS X v10.6 Snow Leopard (19 pages)
- iWork '09 (372 pages)
- Mac OS X v10.6 Snow Leopard (7 pages)
- GarageBand '08 (102 pages)
- iDVD '08 (35 pages)
- GarageBand '09 (122 pages)
- iWeb (37 pages)
- iMovie '08 (50 pages)
- Boot Camp (Mac OS X v10.5 Leopard) (27 pages)
- Boot Camp (Mac OS X v10.5 Leopard) (25 pages)
- Mac OS X v10.5 Leopard (16 pages)
- Mac OS X (622 pages)
- Mac OS X Server (Version 10.6 Snow Leopard) (197 pages)
- Mac OS (42 pages)
- Mac OS X Server (Upgrading and Migrating For Version 10.4 or Later) (97 pages)
- iMovie HD (47 pages)
- iMovie HD (83 pages)
- MAC OS 7.6.1 (4 pages)
- Mac OS X Server (Extending Your Wiki Server For Version 10.5 Leopard) (45 pages)
- Mac OS X Server Ver 10.4 (35 pages)
- Mac OS X Server v10.6 (76 pages)
- Mac OS X Server v10.6 (97 pages)
- Macintosh Japanese Language Kit (30 pages)
- Xserve (Early 2008) DIY Procedure for Hard Drive (3 pages)
- Xserve (8 pages)
- Xserve (60 pages)
- GarageBand 3 (98 pages)
- Remote Desktop 3.1 (191 pages)
- Motion 5.1.1 (1090 pages)
- Workgroup Server 8150/110 (144 pages)
- Aperture (476 pages)
- Xserve Intel (Late 2006) DIY Procedure for Optical Drive Cable (7 pages)
- Xserve Intel (Late 2006) DIY Procedure for Optical Drive Cable (6 pages)
- Network Services Location Manager Network (8 pages)
- Macintosh System 7.5 (114 pages)
- Macintosh System 7.5 (65 pages)
- Macintosh System 7.5 (126 pages)
- DVD Studio Pro 4 (656 pages)
- Keynote '08 (204 pages)
- Xsan 2 (Second Edition) (11 pages)
- LiveType 2 (157 pages)