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	(2013) 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 certain 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	(2013) The number of the ISO week of the year for a given date.
MINUTE	The minute as an integer given a date serial number.
MONTH	The month as in integer given a date serial number.
NETWORKDAYS	(NETWORKDAYS.INTL) The total number of working days between two dates excluding weekends and holidays.
NETWORKDAYS.INTL	The total 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 the hour, minute and 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.
WORKDAY	(WORKDAY.INTL) The date serial number that is a given number of working days before or after a date.
WORKDAY.INTL	(2010) 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.