NETWORKDAYS
 

I have a formula that is working fine for calculating the time between dates:

=IF((O3<"")*(N3<""),(O3-N3),"")

I need to change it to business days between dates. I tried:

=IF((O3<"")*(N3<""),NETWORKINGDAYS(O3,N3),"")

The "#Name!" is returned. Any ideas? Thanks.

NETWORKDAYS
 

you have networkdays in the subject and networkINGdays in the formula.

--


Gary Keramidas
Excel 2003


"PAL" wrote in message
...
I have a formula that is working fine for calculating the time between dates:

=IF((O3<"")*(N3<""),(O3-N3),"")

I need to change it to business days between dates. I tried:

=IF((O3<"")*(N3<""),NETWORKINGDAYS(O3,N3),"")

The "#Name!" is returned. Any ideas? Thanks.

NETWORKDAYS
 

There is no such function as NETWORKINGDAYS
You had it right in the subject line of the post. It is NETWORKDAYS
If you have problems with that, look at Excel help for NETWORKDAYS
--
David Biddulph

"PAL" wrote in message
...
I have a formula that is working fine for calculating the time between
dates:

=IF((O3<"")*(N3<""),(O3-N3),"")

I need to change it to business days between dates. I tried:

=IF((O3<"")*(N3<""),NETWORKINGDAYS(O3,N3),"")

The "#Name!" is returned. Any ideas? Thanks.