NETWORKDAYS

P

PAL

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.
 
D

David Biddulph

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
 
Top