The functions have been grouped by category, to help you to find the function you need. Each function link provides a full description of the function, with examples of use and common errors. Note that some of the Excel functions listed below are new to Excel 2013 or Excel 2016, so are not available in earlier versions of Excel.
Current Date & Time
Returns today’s date.
Returns the current date & time.
Extracting the components of Time
Returns the hour part of a user-supplied time.
Returns the minute part of a user-supplied time.
Returns the seconds part of a user-supplied time.
Extracting the components of Date
Returns the day (of the month) from a user-supplied date.
Returns the month from a user-supplied date.
Returns the year from a user-supplied date.
Returns an integer representing the week number (from 1 to 53) of the year from a user-supplied date.
Returns an integer representing the day of the week for a supplied date.
Creating Date & Times
Returns a date, from a user-supplied year, month and day.
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.
Performing Calculations with Dates
returns the difference between two date values in years, months, or days.
Returns the number of whole networkdays (excluding weekends & holidays), between two supplied dates.
Returns the number of whole networkdays (excluding weekends & holidays), between two supplied dates, using parameters to specify weekend days (New in Excel 2010).
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).
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.
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).
YEARFRAC
Calculates the fraction of the year represented by the number of whole days between two dates.