Help with Networkdays Calculation

S

Scoooter

Dear All

I am currently having problems with the Networkdays calculation in that
my received date is keyed straight away but my due date may remain
blank for sometime. It being blank then throws up a negative number
such as -27887. Is there anyway to have the cell return an "N/a"
if the due date (AN2) is blank?

=NETWORKDAYS(U2,AN2,Holidays!$B$7:$B$14)

Any help would be greatly appreciated.

Thank you
Scoooter
 

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

Top