In This Chapter
This appendix lists all Numbers’ functions, grouped by category. For details about using functions in formulas, see Chapter 4. The following Numbers for Mac functions are not available on Numbers for iPad: BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2OCT, HYPERLINK, NUMTOBASE, OCT2BIN, and OCT2HEX.
DATE(year, month, day)
Returns the date/time value for a given year, month, and day.
DATEDIF(start-date, end-date, calc-method)
Returns the number of days, months, or years between two dates.
Converts a date text string to a date/time value. This ...