Before using the Date and Time functions, it is advised that you ensure you have a clear understanding of the way Excel stores dates and times. For details, see the Dates and Times page.

FunctionCategoryDescription
DATECreating Date/TimeReturns the serial number of a particular date
DATEDIFDate CalculationCalculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.
DATEVALUECreating Date/TimeConverts a date in the form of text to a serial number
DAYDate ComponentsConverts a serial number to a day of the month
DAYSDate CalculationReturns the number of days between two dates (New in Excel 2013)
DAYS360Date CalculationCalculates the number of days between two dates based on a 360-day year
EDATEDate CalculationReturns the serial number of the date that is the indicated number of months before or after the start date
EOMONTHDate CalculationReturns the serial number of the last day of the month before or after a specified number of months
HOURTime ComponentsConverts a serial number to an hour
ISOWEEKNUMDate ComponentsReturns the number of the ISO week number of the year for a given date (New in Excel 2013)
MINUTETime ComponentsConverts a serial number to a minute
MONTHDate ComponentsConverts a serial number to a month
NETWORKDAYSDate CalculationReturns the number of whole workdays between two dates
NETWORKDAYS.INTLDate CalculationReturns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days (New in Excel 2010)
NOWCurrent Date/TimeReturns the serial number of the current date and time
SECONDTime ComponentsConverts a serial number to a second
TIMECreating Date/TimeReturns the serial number of a particular time
TIMEVALUECreating Date/TimeConverts a time in the form of text to a serial number
TODAYCurrent Date/TimeReturns the serial number of today's date
WEEKDAYDate ComponentsConverts a serial number to a day of the week
WEEKNUMDate ComponentsConverts a serial number to a number representing where the week falls numerically with a year
WORKDAYDate CalculationReturns the serial number of the date before or after a specified number of workdays
WORKDAY.INTL Date CalculationReturns 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 (New in Excel 2010)
YEARDate ComponentsConverts a serial number to a year
YEARFRACDate CalculationReturns the year fraction representing the number of whole days between start_date and end_date