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, ...)
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_number, [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])
Date and time
Those functions allows to make calculations with dates and times.