Date & Time Functions

DATE	The date as a date serial number given a year, month, day.
DATEDIF	(Compatibility) The number of days, months or years between two dates.
DATEVALUE	The date serial number given a date in text format.
DAY	The day as an integer given a date serial number.
DAYS	The number of days between two dates.
DAYS360	The number of days between two dates, based on 30 day months.
EDATE	The date serial number that is a given number of months before or after a date.
EOMONTH	The date serial number of the last day of a month before or after a date.
HOUR	The hour as an integer given a date serial number.
ISOWEEKNUM	The week number in the year for a given date (based on European convention).
MINUTE	The minute as an integer given a date serial number.
MONTH	The month as an integer given a date serial number.
NETWORKDAYS	(NETWORKDAYS.INTL) The number of working days between two dates excluding weekends and holidays.
NETWORKDAYS.INTL	The number of working days between two dates excluding weekends and holidays.
NOW	The date serial number of the current system date and time.
SECOND	The number of seconds as an integer given a date serial number.
TIME	The time as a decimal given an hour, minute, second.
TIMEVALUE	The time as a decimal given a time in text format.
TODAY	The date serial number representing today's date.
WEEKDAY	The day of the week for a given date.
WEEKNUM	The week number in the year for a given date (based on US convention).
WORKDAY	(WORKDAY.INTL) The date serial number that is a given number of working days before or after a date.
WORKDAY.INTL	The date serial number that is a given number of working days before or after a date.
YEAR	The year as an integer given a date serial number.
YEARFRAC	The number of years as a decimal between two dates.

DATE The date as a date serial number given a year, month, day.
DATEDIF (Compatibility) The number of days, months or years between two dates.
DATEVALUE The date serial number given a date in text format.
DAY The day as an integer given a date serial number.
DAYS The number of days between two dates.
DAYS360 The number of days between two dates, based on 30 day months.
EDATE The date serial number that is a given number of months before or after a date.
EOMONTH The date serial number of the last day of a month before or after a date.
HOUR The hour as an integer given a date serial number.
ISOWEEKNUM The week number in the year for a given date (based on European convention).
MINUTE The minute as an integer given a date serial number.
MONTH The month as an integer given a date serial number.
NETWORKDAYS (NETWORKDAYS.INTL) The number of working days between two dates excluding weekends and holidays.
NETWORKDAYS.INTL The number of working days between two dates excluding weekends and holidays.
NOW The date serial number of the current system date and time.
SECOND The number of seconds as an integer given a date serial number.
TIME The time as a decimal given an hour, minute, second.
TIMEVALUE The time as a decimal given a time in text format.
TODAY The date serial number representing today's date.
WEEKDAY The day of the week for a given date.
WEEKNUM The week number in the year for a given date (based on US convention).
WORKDAY (WORKDAY.INTL) The date serial number that is a given number of working days before or after a date.
WORKDAY.INTL The date serial number that is a given number of working days before or after a date.
YEAR The year as an integer given a date serial number.
YEARFRAC The number of years as a decimal between two dates.