Using Date Functions in Excel 2007/2010
There are many ways to use the Date functions in Excel. Previous Tech
Tips have included:
Calculate a Person's Age in Excel;
Calculate Remaining Days in the Year; and
Calculate the Days, Months or Years between Dates in Excel.
A lesser known date function is NETWORKDAYS, which returns
the number of work days between two dates. For example:
The format for this function is:
NETWORKDAYS(start_date,end_date,[holidays]). Holidays is optional.
The following tutorials can help you learn to use of the Date functions in
Excel:
Excel 2007 / 2010 Date Functions: Working with Dates in Excel from
www.about.com
Microsoft Excel 2007 to 2010: The Date Function in Excel from
www.homeandlearn.co.uk
|
