Excel Date and TIme Functions

Special

Excel Functions

2003

Special

Excel Functions

2007

Lesson 2: Excel Spreadsheets Date and Time Functions (21)

Note: The DATEDIF function does not show in the drop-down list of Excel functions (even in Excel 2007).

In annex 2 you have found a description of all 21 Excel functions in the "Date and Time" category. Below is the list of the 9 most useful ones.

Functions	What it Does
DATE	Returns the serial number of a particular date
DATEDIF	Calculates the interval in days, months or years between two dates
DAY	Converts a serial number to a day of the month
HOUR	Converts a serial number to an hour
MINUTE	Converts a serial number to a minute
MONTH	Converts a serial number to a month
SECOND	Converts a serial number to a second
TIME	Returns the serial number of a particular time
TODAY	Returns the serial number of today's date
YEAR	Converts a serial number to a year
NOW	Returns the serial number of the current date and time
WEEKDAY	Converts a serial number to a day of the week

In the downloadable tutorial on Excel functions and formulas you will find example of formulas using each of these functions and even many of them assembled in easy and powerful formulas.

If you are using a version of Excel earlier than 2007 you need to activate the " Excel Analysis Toolpack" to make the a few of the functions above available.

Excel Functions and Formulas Sitemap

Go to the next lesson:
Lesson 3: Excel Engineering Functions

See the complete version of this lesson in
The Tutorial on Excel
Functions

SUMPRODUCT ¦ INDEX/MATCH ¦ SUBTOTAL ¦ ISERROR ¦ COUNTIF ¦ SUMIF ¦ HLOOKUP ¦ LOOKUP ¦ VLOOKUP
AVERAGEIF ¦ AVERAGEIFS ¦ COUNTIFS ¦ SUMIFS ¦ IFERROR