Formulas and Functions

42
The date and time functions help you work with dates and
times to solve problems such as nding the number of
working days between two dates or nding the name of the
day of the week a date will fall on.
Listing of Date and Time Functions
iWork includes these date and time functions for use with tables.
Function Description
“DATE” (page 44) 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 specied in System Preferences (search for
“date format” in the System Preferences window).
“DATEDIF” (page 45) The DATEDIF function returns the number of
days, months, or years between two dates.
“DATEVALUE” (page 47) The DATEVALUE function converts a date
text string and returns a date/time value. This
function is provided for compatibility with other
spreadsheet programs.
“DAY” (page 47) The DAY function returns the day of the month
for a given date/time value.
“DAYNAME” (page 48) The DAYNAME function returns the name of
the day of the week from a date/time value or a
number. Day 1 is Sunday.
“DAYS360” (page 49) The DAYS360 function returns the number of
days between two dates based on twelve 30-day
months and a 360-day year.
3
Date and Time Functions