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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Statements - to include calculation? 5
accepting most recent date across columns 10
How do I reference a cell as a row number in a formula? 4
Excel Formula 7
trouble with financial balancing 1
sum question 4
Vlookup will not retrun value 2
MACRO, syntax for move to different column 1

Top