At last count, Excel 365 offers 25 worksheet functions that return date or time information.
The links are to the Microsoft help topics for each function.
| Function | Description |
| DATE | Returns the date serial number of a specified date |
| DATEDIF | Calculates the number of days, months, or years between two dates. |
| DATEVALUE | Converts a date in the form of text to a serial number |
| DAY | Returns the day number for a date serial number |
| DAYS | Returns the number of days between two dates |
| 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 |
| ISOWEEKNUM | Returns the number of the ISO week number of the year for a given date |
| MINUTE | Converts a serial number to a minute |
| MONTH | Returns the month number for a date serial number |
| NETWORKDAYS | Returns the number of whole workdays between two dates |
| NETWORKDAYS.INTL | Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days |
| 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 |
| WORKDAY.INTL | Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days |
| YEAR | Returns the year for a date serial number |
| YEARFRAC | Returns the year fraction representing the number of whole days between start_date and end_date |
