DATE AND TIME FUNCTIONS

4 DATE : Returns the serial number of a particular date
4 DATEVALUE : Converts a date in the form of text to a serial number
4 DAY : Converts a serial number to a day of the month
4 DAYS360 : Calculates the number of days between two dates based on a 360-day year
4 EDATE : Returns the serial number of the date that is the indicated number of months before or after the start date
4 EOMONTH : Returns the serial number of the last day of the month before or after a specified number of months
4 HOUR : Converts a serial number to an hour
4 MINUTE : Converts a serial number to a minute
4 MONTH : Converts a serial number to a month
4 NETWORKDAYS : Returns the number of whole workdays between two dates
4 NOW : Returns the serial number of the current date and time
4 SECOND : Converts a serial number to a second
4 TIME : Returns the serial number of a particular time
4 TIMEVALUE : Converts a time in the form of text to a serial number
4 TODAY : Returns the serial number of today's date
4 WEEKDAY : Converts a serial number to a day of the week
4 WEEKNUM : Converts a serial number to a number representing where the week falls numerically with a year
4 WORKDAY : Returns the serial number of the date before or after a specified number of workdays
4 YEAR : Converts a serial number to a year
4 YEARFRAC : Returns the year fraction representing the number of whole days between start_date and end_date