Apple iWork '09 - Manual (Page 44)

Function Description
“WEEKDAY” (page 59) The WEEKDAY function returns a number that is
the day of the week for a given date.
“WEEKNUM” (page 60) The WEEKNUM function returns the number of
the week within the year for a given date.
“WORKDAY” (page 61) The WORKDAY function returns the date that is
the given number of working days before or after
a given date. Working days exclude weekends
and any other dates specifically excluded.
“YEAR” (page 62) The YEAR function returns the year for a given
date/time value.
“YEARFRAC” (page 63) The YEARFRAC function finds the fraction of a
year represented by the number of whole days
between two dates.
DATE
The DATE function combines separate values for year, month, and day and returns a
date/time value. Although dates can usually be entered directly as strings (for example,
“12/31/2010”), using the DATE function ensures the date will be interpreted consistently
regardless of the date format specified in System Preferences (search for “date format”
in the System Preferences window).
DATE(year, month, day)
 year: The year to include in the value returned. year is a number value. The value
isn’t converted. If you specify 10, the year 10 is used, not the year 1910 or 2010.
 month: The month to include in the value returned. month is a number and should
be in the range 1 to 12.
 day: The day to include in the value returned. day is a number value and should be
in the range 1 to the number of days in month.
Examples
If A1 contains 2014, A2 contains 11, and A3 contains 10:
=DATE(A1, A2, A3) returns Nov 10, 2014, which is displayed according to the cell’s current format.
=DATE(A1, A3, A2) returns Oct 11, 2014.
=DATE(2012, 2, 14) returns Feb 14, 2012.
Related Topics
For related functions and additional information, see:
“DURATION” on page 70
44 Chapter 3 Date and Time Functions