NETWORKDAYS

  • Thread starter Thread starter PAL
  • Start date Start date
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.
 
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
 
Back
Top