Overview of Excel’s Date Functions

This table summarizes the performance of 24 worksheet functions that primarily are designed to work with dates and times.

91

This table summarizes the performance of Excel's worksheet functions primarily designed to work with dates

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