EXCEL NETWORKDAYS FUNCTION

T

TLAngelo

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

Fred Smith

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.
 
R

Roger Govier

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)
 
Top