Complete List of Excel Date and Time Functions, References and Examples
Before using the Date and Time Excel Functions, it is advised that you ensure you have a clear understanding of the way Excel stores Dates and Times
Here’s a full list of Built-In Date and Time Excel Functions in Excel and their Descriptions below:
Click each of the function link to see detailed example.
Creating Dates & Times |
|
| DATE | Returns a date, from a user-supplied year, month and day |
| TIME | Returns a time, from a user-supplied hour, minute and second |
| DATEVALUE | Converts a text string showing a date, to an integer that represents the date in Excel’s date-time code |
| TIMEVALUE | Converts a text string showing a time, to a decimal that represents the time in Excel |
Current Date & Time |
|
| NOW | Returns the current date & time |
| TODAY | Returns today’s date |
Extracting The Components of a Time |
|
| HOUR | Returns the hour part of a user-supplied time |
| MINUTE | Returns the minute part of a user-supplied time |
| SECOND | Returns the seconds part of a user-supplied time |
Extracting The Components of a Date |
|
| DAY | Returns the day (of the month) from a user-supplied date |
| MONTH | Returns the month from a user-supplied date |
| YEAR | Returns the year from a user-supplied date |
| WEEKNUM | Returns an integer representing the week number (from 1 to 53) of the year from a user-supplied date |
| ISOWEEKNUM | Returns the ISO week number of the year for a given date (New in Excel 2013) |
| WEEKDAY | Returns an integer representing the day of the week for a supplied date |
Performing Calculations with Dates |
|
| EDATE | Returns a date that is the specified number of months before or after an initial supplied start date |
| EOMONTH | Returns a date that is the last day of the month which is a specified number of months before or after an initial supplied start date |
| WORKDAY | Returns a date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start date |
| WORKDAY.INTL | Returns a date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start date, using supplied parameters to specify weekend days (New in Excel 2010) |
| DAYS | Calculates the number of days between 2 dates (New in Excel 2013) |
| DAYS360 | Calculates the number of days between 2 dates, based on a 360-day year (12 x 30 months) |
| NETWORKDAYS | Returns the number of whole networkdays (excluding weekends & holidays), between two supplied dates |
| NETWORKDAYS.INTL | Returns the number of whole networkdays (excluding weekends & holidays), between two supplied dates, using parameters to specify weekend days (New in Excel 2010) |
| YEARFRAC | Calculates the fraction of the year represented by the number of whole days between two dates |
Note: Excel stores dates as numbers