Date and Time functions

Status	Column 1	Title
Not started	Function	Description
Not started	DATE	Returns the serial number of a particular date
Not started	DATEDIF	Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.
Not started	DATEVALUE	Converts a date in the form of text to a serial number
Not started	DAY	Converts a serial number to a day of the month
Not started	DAYS (2013)	Returns the number of days between two dates
Not started	DAYS360	Calculates the number of days between two dates based on a 360-day year
Not started	EDATE	Returns the serial number of the date that is the indicated number of months before or after the start date
Not started	EOMONTH	Returns the serial number of the last day of the month before or after a specified number of months
Not started	HOUR	Converts a serial number to an hour
Not started	ISOWEEKNUM (2013)	Returns the number of the ISO week number of the year for a given date
Not started	MINUTE	Converts a serial number to a minute
Not started	MONTH	Converts a serial number to a month
Not started	NETWORKDAYS	Returns the number of whole workdays between two dates
Not started	NETWORKDAYS.INTL (2010)	Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days
Not started	NOW	Returns the serial number of the current date and time
Not started	SECOND	Converts a serial number to a second
Not started	TIME	Returns the serial number of a particular time
Not started	TIMEVALUE	Converts a time in the form of text to a serial number
Not started	TODAY	Returns the serial number of today's date
Not started	WEEKDAY	Converts a serial number to a day of the week
Not started	WEEKNUM	Converts a serial number to a number representing where the week falls numerically with a year
Not started	WORKDAY	Returns the serial number of the date before or after a specified number of workdays
Not started	WORKDAY.INTL (2010)	Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days
Not started	YEAR	Converts a serial number to a year
Not started	YEARFRAC	Returns the year fraction representing the number of whole days between start_date and end_date

Date and Time functions

Untitled