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.