|
<< Click to Display Table of Contents >> NETWORKDAYS (number of workdays) |
Syntax:
NETWORKDAYS(StartDate, EndDate [, Holidays])
Description:
This returns the number of workdays between StartDate and EndDate.
This function counts workdays only, and Saturdays and Sundays are skipped. You also have the option of specifying a list of holidays to be skipped as well (see Holidays parameter).
StartDate and EndDate are the first and the last day of the time interval to be evaluated.
Holidays (optional) is a cell range or an array containing a list of dates to be skipped (e.g., holidays).
Example:
NETWORKDAYS("01/01/2010", "01/31/2010") returns 22.
January 2010 thus had 22 work days (not including public holidays).
If you want to include the holidays on 1/1/2010 and 1/6/2010 (in most European countries), you can enter these two dates in cells A1 and A2, for example, and then write them as follows:
NETWORKDAYS("01/01/2010, "01/31/2010", A1:A2)
The result is 20, as these holidays both fell on weekdays in 2010, so 2 days are to be deducted.
See also: