ExcelFunctions.net
Excel Date and Time Functions
Home »
Excel-Built-In-Functions »
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
|
|
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)
|
|
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
