| Function
| Description
|
| 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 |