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