Learn About Dated Functions

Excel Date and Time Functions

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 - For details, see the Excel Dates and Times pages.

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