Date and Time Functions

Function	Description	Status
DATE function	Returns the serial number of a particular date	Not started
DATEDIF function	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 function	Converts a date in the form of text to a serial number	Not started
DAY function	Converts a serial number to a day of the month	Not started
DAYS function	Returns the number of days between two dates	Not started
DAYS360 function	Calculates the number of days between two dates based on a 360-day year	Not started
EDATE function	Returns the serial number of the date that is the indicated number of months before or after the start date	Not started
EOMONTH function	Returns the serial number of the last day of the month before or after a specified number of months	Not started
HOUR function	Converts a serial number to an hour	Not started
ISOWEEKNUM function	Returns the number of the ISO week number of the year for a given date	Not started
MINUTE function	Converts a serial number to a minute	Not started
MONTH function	Converts a serial number to a month	Not started
NETWORKDAYS function	Returns the number of whole workdays between two dates	Not started
NETWORKDAYS.INTL function	Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days	Not started
NOW function	Returns the serial number of the current date and time	Not started
SECOND function	Converts a serial number to a second	Not started
TIME function	Returns the serial number of a particular time	Not started
TIMEVALUE function	Converts a time in the form of text to a serial number	Not started
TODAY function	Returns the serial number of today's date	Not started
WEEKDAY function	Converts a serial number to a day of the week	Not started
WEEKNUM function	Converts a serial number to a number representing where the week falls numerically with a year	Not started
WORKDAY function	Returns the serial number of the date before or after a specified number of workdays	Not started
WORKDAY.INTL function	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 function	Converts a serial number to a year	Not started
YEARFRAC function	Returns the year fraction representing the number of whole days between start_date and end_date	Not started