=IF(COUNT(A1,A9)=2,NETWORKDAYS(A1, A9),"")
--
David Biddulph

"Edward" wrote in message
...
Hi, I have a section of a worksheet that just needs to show working days
between two dates.
For example, an order was entered on 9/2/07 and complete on 9/15/07

The formula =NETWORKDAYS(A1, A9) works perfectly except that until the
"completed date" ise filled in, a negative number appears.

Is there a way to have that remain blank until both dates have been
entered?

Thanks!