NETWORKDAYS Function

[M Hadley]

Can I access the list of holidays Excel uses for this
funtion and change the list?

Thanks

 

[Chip Pearson]

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.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Harlan Grove]

Can I access the list of holidays Excel uses for this
funtion and change the list?

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.

 

[M Hadley]

Chip,

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.

Thanks
Mary

 

[Chip Pearson]

Mary,

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.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)