Excel Date and Time Functions

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:

FunctionDescription
DATE FunctionSerial number of a date based on year, month and day.
DATEDIF FunctionNumber of days, months or years between two dates.
DATEVALUE FunctionConvert a date in the text format to a serial number.
DAY FunctionCalculate the day value from a date.
DAYS FunctionNumber of days between two dates.
DAYS360 FunctionNumber of days between two dates based on 360 days in a year.
EDATE FunctionPast or future month(s) from a start date.
EMONTH FunctionLast day of the month before or after a given number of months.
HOUR FunctionHour (0 to 23) from a time value.
ISOWEEKNUM FunctionWeek number from a date based on ISO (International Organization for Standardization).
MINUTE FunctionMinute (0 to 59) from a time value.
MONTH FunctionMonth (1 to 12) from a time value.
NETWORKDAYS FunctionNumber of working days between two dates using holidays.
NETWORKDAYS.INTL FunctionNumber of working days between two dates using weekend days.
NOW FunctionCurrent date and time.
SECOND FunctionSecond (0 to 59) from a time value.
TIME FunctionDecimal number for a specific time.
TIMEVALUE FunctionDecimal number for a specific time in the form of text.
TODAY FunctionCurrent date.
WEEDAY FunctionDay of the week (1 to 7) from a date.
WEEKNUM FunctionWeek number (1 to 54) from a date.
WORKDAY FunctionDate before or after a specified number of working days.
WORKDAY.INTL FunctionDate before or after a specified number of working days using weekend days.
YEAR FunctionYear (1900 to 9999) from a date.
YEARFRAC FunctionYear or fraction of the year between two dates.