Overview of Excel's Date Functions

This table summarizes the performance of Excel's worksheet functions primarily designed to work with dates

by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

These are the 24 worksheet functions that return date or time information in the current version of Excel.

I've completed the topics for the function names with hyperlinks.

Date Functions and Descriptions
DATE	Returns the date serial number of a specified date
DATEVALUE	Converts a date in the form of text to a serial number
DAY	Returns the day number for a date serial number
DAYS	Returns the number of days between two dates
DAYS360	Calculates the number of days between two dates based on a 360-day year
EDATE	Returns the serial number of the date that is the indicated number of months before or after the start date
EOMONTH	Returns the serial number of the last day of the month before or after a specified number of months
HOUR	Converts a serial number to an hour
ISOWEEKNUM	Returns the number of the ISO week number of the year for a given date
MINUTE	Converts a serial number to a minute
MONTH	Returns the month number for a date serial number
NETWORKDAYS	Returns the number of whole workdays between two dates
NETWORKDAYS.INTL	Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days
NOW	Returns the serial number of the current date and time
SECOND	Converts a serial number to a second
TIME	Returns the serial number of a particular time
TIMEVALUE	Converts a time in the form of text to a serial number
TODAY	Returns the serial number of today's date
WEEKDAY	Converts a serial number to a day of the week
WEEKNUM	Converts a serial number to a number representing where the week falls numerically with a year
WORKDAY	Returns the serial number of the date before or after a specified number of workdays
WORKDAY.INTL	Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days
YEAR	Returns the year for a date serial number
YEARFRAC	Returns the year fraction representing the number of whole days between start_date and end_date

About | Contact | Site Map | Downloads | Earn advertising fees

ExcelUser, Inc. Copyright © 2004 - 2017 by Charles W. Kyd, all rights reserved. Content, graphics, and HTML code are protected by US and International Copyright Laws, and may not be copied, reprinted, published, translated, hosted, or otherwise distributed by any means without explicit permission. Terms of Use | Privacy Policy | Disclaimer | Earnings Policy.

Ref: 901 181