Excel doesn't use a list of holidays. You have to provide the list of dates
yourself. For example, if cells A1:A10 contain the list of holidays, you
would use a formula like
=NETWORKDAYS(start,end,A1:A10)
If you don't provide a list of holidays, then holidays are not used in
calculating the number of days.
No because Excel has no such list. It's an *optional* parameter to NETWORKDAYS,
meaning if you don't pass NETWORKDAYS a 3rd argument either as an array constant
of holiday dates or a reference to such a list, NETWORKDAYS will could all
weekdays between the two dates. See online help for this function.
Thanks for answering my question. Unfortunately, when I
calculate the networkdays between 10/13/03 and 10/14/03,
Excel says it is 2. It recognizes 10/13/03 as a holiday
(Columbus Day). I want to change the holidays it
recognizes.
Excel isn't recognizing Columbus Day. NETWORKDAYS dates are inclusive, so
for the dates 10/13 and 10/14, the number of working days is 2, as
NETWORKDAYS correctly calculates. If Excel did automatically include
Columbus Day, the answer would be 1.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
