| DATE | The serial number of a date given the year, month, day. |
| DATEDIF* | The number of units between two dates. |
| DATEVALUE | The serial number that represents a given date in text format. |
| DAY | The day as an integer given a date serial number. |
| DAYS360 | The number of days between two dates, based on 30 day months. |
| EDATE* | The serial number that is a given number of months before or after a date. |
| EOMONTH* | The serial number of the last day of a month before or after a date. |
| HOUR | The hour as an integer given a date serial number. |
| MINUTE | The minute as an integer given a date serial number. |
| MONTH | The month as in integer given a date serial number. |
| NETWORKDAYS* | The number of days between two dates excluding weekends and holidays. |
| NOW | The date serial number of the current system date and time. |
| SECOND | The number of seconds given a date serial number. |
| TIME | The time as a decimal given the hour, minute and second. |
| TIMEVALUE | The time as a decimal returned as text given a date serial number. |
| TODAY | The serial number representing today's date. |
| WEEKDAY | The day of the week for a given date. |
| WEEKNUM* | The week number in the year for a given date. |
| WORKDAY* | The serial number before or after a given number of days from a given date. |
| YEAR | The year as an integer given a date serial number. |
| YEARFRAC* | The number of years as a decimal between two dates. |
