Date and time
23 functions in this section.
| DATE | Returns a date representing the given year, month and day. |
| DATETIME | Returns a temporal value representing the given year, month, day, hour, minute and second. |
| DAY | Returns the day of the month of a given date, as a number from 1 through 31. |
| DAYS | Returns the number of days between two dates. |
| DAYS360 | Returns the number of days between two dates. |
| EDATE | Returns a date advanced or set back a number of months. |
| EOMONTH | Returns a date representing the last day of a particular month, potentially set back or advanced a number of months. |
| HOUR | Returns the hour of a given date, as a number from 0 through 23. |
| ISOWEEKNUM | Returns the ISO week number of the given date, from 1 through 53. |
| MINUTE | Returns the minute of a given date, as a number from 0 through 59. |
| MONTH | Returns the month of a given date, as a number from 1 (January) through 12 (December). |
| NETWORKDAYS | Returns the number of working days between two dates. |
| NETWORKDAYS.INTL | Returns the number of working days between two dates. |
| NOW | Returns the current date and time. |
| SECOND | Returns the second of a given date, as a number from 0 through 59. |
| TIME | Returns a temporal value representing the given hour, minute and second. |
| TODAY | Returns the current date, with the time set to midnight. |
| WEEKDAY | Returns the day of the week of the given date. |
| WEEKNUM | Converts a date to a number representing the week number of the date. |
| WORKDAY | Returns a date advanced or set back a number of working days. |
| WORKDAY.INTL | Returns a date advanced or set back a number of working days. |
| YEAR | Returns the year of a given date. |
| YEARFRAC | Returns the number of years between the two given dates, as a decimal number. |