QUESTION REGARDING HOLIDAYS

[TLAngelo]

I have a worksheet that calculates process times. I have a formula that
calculates process times and excludes weekends and non working hours. How do
I get it to skip holidays?

This is my formula I'm using now:

=IF(A19="NA",(0),(NETWORKDAYS(B19,M19)-1)/2.4+(N19-C19))

b19 is date in, m19 is date out, n19 is time out, and c19 is time in.

Do I have to specify somewhere what the holidays are? I'm using 2007 if
that makes any difference.

Tania

 

[Fred Smith]

Read the Help on Networkdays. It will handle holidays. You just have to tell
it which ones you want.

Regards,
Fred.

 

[TLAngelo]

I did read the help before I asked this question. I don't understand if I
need to specify somewhere what the holidays are or how to get it into my
formula that I am already using.

Tania

 

[David Biddulph]

Have you looked at Excel help for the NETWORKDAYS function?

 

[David Biddulph]

Tell us which part of the help for NETWORKDAYS you don't understand. It
looks crystal clear to me. It tells you the syntax and it gives you
examples.

 

[TLAngelo]

It isn't crystal clear to me, I'm sorry.

Do I need to add a list of holidays somewhere on my worksheet? I tried
doing that and then when I try to add it to my formula it says I have to many
arguments.

Tania

 

[Dave Peterson]

Adding a list to a worksheet and naming that list seems like the easiest way to
me.

Then the portion of the formula that would use that named range would look like:
....NETWORKDAYS(B19,M19,HolidayList)....

If this doesn't help, post what you tried.

 

[David Biddulph]

Why not tell us what formula you tried to use that gave you that error
message?

 

[TLAngelo]

Thanks so much Dave! That worked perfectly! Thanks for taking the time to
help.

Tania