Excel Date and Time Functions

This page lists the current, built-in Excel Date and Time Functions. These functions are provided by Excel, to help you to work with dates and times.

Before using Excel Date and Time Functions, it will help if you have an understanding of the way dates and times are stored in Excel - this is explained in the Excel Dates and Times pages.

The functions listed below have been grouped into categories, to help you to find the function you need to perform a specific task. Note that some of the functions are new to Excel 2010, so are not available in earlier versions of Excel. If you select a function name, this will take you to a full description of the function, with examples of use, tips & tricks, and common errors.


Excel Date and Time Functions List

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

There is an excellent tutorial that gives examples of use of many of the Excel Date and Time Functions on the Microsoft Office Training Pages

Return to the List of All Built-In Excel Functions

Return to the ExcelFunctions.net Home Page

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net