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

Tania

"Dave Peterson" wrote:

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.


TLAngelo wrote:

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

"David Biddulph" wrote:

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.
--
David Biddulph

"TLAngelo" wrote in message
...
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

"Fred Smith" wrote:

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

Regards,
Fred.

"TLAngelo" wrote in message
...
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






--

Dave Peterson