Apple Numbers '08 - Manual (Page 195)

Chapter 12 Dictionary of Functions 195
Date and Time Functions
The date and time functions perform calculations on date, time, or numeric
expressions.
Numbers includes these date and time functions.
Function Description
DATE (page 224) Combines individual year, month, and day numbers into a single
date.
DATEDIF (page 225) Finds the time interval between two dates.
DAY (page 226) Extracts the day number from a date.
EDATE (page 229) Finds the date some number of months before or after a given
date.
HOUR (page 235) Extracts the hour (in the range 0 through 23) from a date.
MINUTE (page 250) Extracts the minutes from a date.
MONTH (page 251) Extracts the month number from a date.
NOW (page 253) Gets the current date and time from the computer’s clock.
SECOND (page 271) Extracts the seconds from a date.
TIME (page 281) Converts hours, minutes, and seconds into a time format.
TIMEVALUE (page 282) Converts a date, a time, or a text string to a decimal fraction of a
24-hour day.
TODAY (page 282) Gets the current system date and formats the cell to display the
date but not the time.
WEEKDAY (page 289) Converts a date to a number representing the day of the week.
YEAR (page 289) Extracts the year number from a date.