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

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

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

Have you looked at Excel help for the NETWORKDAYS function?
--
David Biddulph

"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

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

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

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

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

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

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