| DATE | DATE(year,month,day)
|
| DATEDIF | DATEDIF(start_date, end_date, unit)
|
| DATEVALUE | DATEVALUE(date_text)
|
DAY
| DAY(serial_number)
|
| DAYS | DAYS(end_date, start_date)
|
| DAYS360 | DAYS360(start_date,end_date,method)
|
EDATE
| EDATE(start_date,months)
|
| EOMONTH | EOMONTH(start_date,months)
|
| HOUR | HOUR(serial_number)
|
| ISOWEEKNUM | ISOWEEKNUM(date)
|
| MINUTE | MINUTE(serial_number)
|
MONTH
| MONTH(serial_number)
|
| NETWORKDAYS | NETWORKDAYS(start_date,end_date,holidays)
|
NETWORKDAYS.INTL
| NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
|
| NOW | NOW( )
|
| SECOND | SECOND(serial_number)
|
TIME
| TIME(hour,minute,second)
|
| TIMEVALUE | TIMEVALUE(time_text)
|
TODAY
| TODAY( )
|
WEEKDAY
| WEEKDAY(serial_number,return_type)
|
| WEEKNUM | WEEKNUM(serial_num,return_type)
|
| WORKDAY | WORKDAY(start_date,days,holidays)
|
| WORKDAY.INTL | WORKDAY.INTL(start_date, days, [weekend], [holidays])
|
| YEAR | YEAR(serial_number)
|
| YEARFRAC | YEARFRAC(start_date,end_date,basis)
|