Date and Time Functions

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