Hi

Networkdays has an optional additional parameter, holidays, to account
for this
=NETWORKDAYS(Start_date,End_date,holidays)
where holidays is either a named range containing the list of holiday
dates you want taken in to consideration, or a range of cell references
where the data is stored.
=NETWORKDAYS(A1,,B1,$H1:$H10)

--
Regards

Roger Govier


"TLAngelo" wrote in message
...
I am using the networdays function to calculate process times. I was
under
the assumption that it compensated for holidays, but it has counted
the 4th
of July as a regular working day, can anyone tell me why?