Number of days and remove error on blanks

Hi.

I have 2 questions please on the enclosed example.

1. How can I replace the error number 43917 shown in Yellow with a text message and when the delivery date in col B is blank.

2. How can i show the number of work days in col D i.e Mon -Fri

Regards
Garry

Hi Hemesh,

Many thanks and that worked for question 1, any ideas on question 2 and how to show network days instead of all days ?

G

Originally Posted by hemesh

in c2 copy paste below and drag down

Formula:

Please Login or Register  to view this content.

for days may be
copy paste below then drag down

Formula:

Please Login or Register  to view this content.

Thats great, many thanks for your quick response, I will close the call

Thanks