|
<< Click to Display Table of Contents >> NETWORKDAYS (number of workdays) |
Syntax:
NETWORKDAYS(StartDate, EndDate [, Holidays])
Description:
Returns the number of workdays between StartDate and EndDate.
This function counts workdays only, Saturdays and Sundays are skipped. Optionally, you can specify 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 therefore had 22 working 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:
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: