Date and time functions (reference)

To get detailed information about a function, click its name in the first column.

Note: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions. For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions.

Function

Description

Returns the serial number of a particular date

Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.

Converts a date in the form of text to a serial number

Converts a serial number to a day of the month

DAYS function Returns the number of days between two dates

Calculates the number of days between two dates based on a 360-day year

Returns the serial number of the date that is the indicated number of months before or after the start date

Returns the serial number of the last day of the month before or after a specified number of months

Converts a serial number to an hour

ISOWEEKNUM function Returns the number of the ISO week number of the year for a given date

Converts a serial number to a minute

Converts a serial number to a month

Returns the number of whole workdays between two dates

NETWORKDAYS.INTL function Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days

Returns the serial number of the current date and time

Converts a serial number to a second

Returns the serial number of a particular time

Converts a time in the form of text to a serial number

Returns the serial number of today's date

Converts a serial number to a day of the week

Converts a serial number to a number representing where the week falls numerically with a year

Returns the serial number of the date before or after a specified number of workdays

WORKDAY.INTL function 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

Converts a serial number to a year

Returns the year fraction representing the number of whole days between start_date and end_date

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.