The Excel date and time functions are used to return the desired output from the date and time in Excel, such as year, month, day, hour, minute, second etc.
Complete List of Excel Date and Time Functions (A to Z)
All Excel date and time functions are mentioned below in alphabetical order:
| Function | Description |
| DATE Function | Serial number of a date based on year, month and day. |
| DATEDIF Function | Number of days, months or years between two dates. |
| DATEVALUE Function | Convert a date in the text format to a serial number. |
| DAY Function | Calculate the day value from a date. |
| DAYS Function | Number of days between two dates. |
| DAYS360 Function | Number of days between two dates based on 360 days in a year. |
| EDATE Function | Past or future month(s) from a start date. |
| EMONTH Function | Last day of the month before or after a given number of months. |
| HOUR Function | Hour (0 to 23) from a time value. |
| ISOWEEKNUM Function | Week number from a date based on ISO (International Organization for Standardization). |
| MINUTE Function | Minute (0 to 59) from a time value. |
| MONTH Function | Month (1 to 12) from a time value. |
| NETWORKDAYS Function | Number of working days between two dates using holidays. |
| NETWORKDAYS.INTL Function | Number of working days between two dates using weekend days. |
| NOW Function | Current date and time. |
| SECOND Function | Second (0 to 59) from a time value. |
| TIME Function | Decimal number for a specific time. |
| TIMEVALUE Function | Decimal number for a specific time in the form of text. |
| TODAY Function | Current date. |
| WEEDAY Function | Day of the week (1 to 7) from a date. |
| WEEKNUM Function | Week number (1 to 54) from a date. |
| WORKDAY Function | Date before or after a specified number of working days. |
| WORKDAY.INTL Function | Date before or after a specified number of working days using weekend days. |
| YEAR Function | Year (1900 to 9999) from a date. |
| YEARFRAC Function | Year or fraction of the year between two dates. |