Apple iWork '09 - Manual (Page 43)

Chapter 3 Date and Time Functions 43
Function Description
“EDATE” (page 50) The EDATE function returns a date that is some
number of months before or after a given date.
“EOMONTH” (page 51) The EOMONTH function returns a date that is the
last day of the month some number of months
before or after a given date.
“HOUR” (page 51) The HOUR function returns the hour for a given
date/time value.
“MINUTE” (page 52) The MINUTE function returns the minutes for a
given date/time value.
“MONTH” (page 53) The MONTH function returns the month for a
given date/time value.
“MONTHNAME” (page 54) The MONTHNAME function returns the name of
the month from a number. Month 1 is January.
“NETWORKDAYS” (page 54) The NETWORKDAYS function returns the number
of working days between two dates. Working
days exclude weekends and any other specified
dates.
“NOW” (page 55) The NOW function returns the current date/time
value from the system clock.
“SECOND” (page 56) The SECOND function returns the seconds for a
given date/time value.
“TIME” (page 56) The TIME function converts separate values for
hours, minutes, and seconds into a date/time
value.
“TIMEVALUE” (page 57) The TIMEVALUE function returns the time as a
decimal fraction of a 24-hour day from a given
date/time value or from a text string.
“TODAY” (page 58) The TODAY function returns the current system
date. The time is set to 12:00 a.m.