Excel date functions
Date functions in Excel, explained with live examples.
25 date functions in Excel — 25 documented in depth so far, the rest indexed below and landing every week.
Documented date functions
Syntax, examples, and the equivalent — ready now.
- DATEReturns the serial number of a particular dateDateGoogle Sheets
- DATEDIFCalculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.DateGoogle Sheets
- DATEVALUEConverts a date in the form of text to a serial numberDateGoogle Sheets
- DAYConverts a serial number to a day of the monthDateGoogle Sheets
- DAYSReturns the number of days between two datesDateGoogle Sheets
- DAYS360Calculates the number of days between two dates based on a 360-day yearDateGoogle Sheets
- EDATEReturns the serial number of the date that is the indicated number of months before or after the start dateDateGoogle Sheets
- EOMONTHReturns the serial number of the last day of the month before or after a specified number of monthsDateGoogle Sheets
- HOURConverts a serial number to an hourDateGoogle Sheets
- ISOWEEKNUMReturns the number of the ISO week number of the year for a given dateDateGoogle Sheets
- MINUTEConverts a serial number to a minuteDateGoogle Sheets
- MONTHConverts a serial number to a monthDateGoogle Sheets
- NETWORKDAYSReturns the number of whole workdays between two datesDateGoogle Sheets
- NETWORKDAYS.INTLReturns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend daysDateGoogle Sheets
- NOWReturns the serial number of the current date and timeDateGoogle Sheets
- SECONDConverts a serial number to a secondDateGoogle Sheets
- TIMEReturns the serial number of a particular timeDateGoogle Sheets
- TIMEVALUEConverts a time in the form of text to a serial numberDateGoogle Sheets
- TODAYReturns the serial number of today's dateDateGoogle Sheets
- WEEKDAYConverts a serial number to a day of the weekDateGoogle Sheets
- WEEKNUMConverts a serial number to a number representing where the week falls numerically with a yearDateGoogle Sheets
- WORKDAYReturns the serial number of the date before or after a specified number of workdaysDateGoogle Sheets
- WORKDAY.INTLReturns 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 daysDateGoogle Sheets
- YEARConverts a serial number to a yearDateGoogle Sheets
- YEARFRACReturns the year fraction representing the number of whole days between start_date and end_dateDateGoogle Sheets
More Excel function categories