Apple numbers User Manual

 Dictionary of Functions

 

Date and Time Functions

The date and time functions perform calculations on date, time, or numeric 
expressions.

Numbers includes these date and time functions.

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.

Extracts the hour (in the range 0 through 23) from a date.

Extracts the minutes from a date.

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.

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.

Extracts the year number from a date.