XL: How to Use NETWORKDAYS() with Multiple Holidays |
Q89507
The information in this article applies to:
- Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
- Microsoft Excel for the Macintosh, versions 4.0, 5.0
SUMMARY
When you use the NETWORKDAYS() function with multiple holidays, you may enter the holidays as cell references or in the serial number format, and you must enclose the dates in braces ({}).
In the NETWORKDAYS() function, dates in the form of text are ignored if your worksheet is in the 1904 date system (Options Calculation). This problem is more likely to occur on the Macintosh platform where the 1904 date system is the default. Dates represented as serial numbers are accepted.
MORE INFORMATION
The NETWORKDAYS() function returns the number of whole working days between two dates. You can use the holidays parameter to exclude specific dates from the calculation. You can enter starting and ending dates directly as serial numbers, as text, through a cell reference, or by using the DATEVALUE() function. You can also enter single holidays this way. However, you must enter multiple holidays in the serial number format only, and you must enclose the set of holiday dates in braces ({}).
The correct way to indicate dates in the form of text is to use the DATEVALUE() function. Also, if you are using an array constant to specify multiple "text" dates for the holidays argument, you must enclose the array constant within the DATEVALUE function. An example is provided in the "Function Reference," page 285.
Examples Listing Dates in the Function
=NETWORKDAYS(DATEVALUE("1/1/92"),DATEVALUE("12/31/92"), DATEVALUE({"12/24/92","12/25/92"}))
-or-
=NETWORKDAYS(DATEVALUE("1/1/92"),DATEVALUE("12/31/92"), {33962,33963})
Examples Using Cell References
A1: 12/24/92
A2: 12/25/92
=NETWORKDAYS(DATEVALUE("1/1/92"),DATEVALUE("12/31/92"),A1:A2)
-or-
A1: 1/1/92
A2: 12/31/92
A3: 12/24/92
A4: 12/25/92
=NETWORKDAYS(A1,A2,A3:A4)
You cannot, however use the following:
A1: 12/24/92
C1: 12/25/92
=NETWORKDAYS(DATEVALUE("1/1/92"),DATEVALUE("12/31/92"),{A1,C1})
REFERENCES
"Function Reference," version 4.0, pages 94, 284-285
Keywords :
Issue type :
Technology :
Last Reviewed: December 15, 2000 |
