EXCEL NETWORKDAYS FUNCTION
 

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?

EXCEL NETWORKDAYS FUNCTION
 

You have to tell the function what holidays are appropriate in your situation.
Not everyone gets July 4th off.

You need to enter a range of holidays as the third parameter in the function.
For additional information, see Help.

--
Regards,
Fred


"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?

EXCEL NETWORKDAYS FUNCTION
 

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?