NETWORKDAYS error

[Wildways]

Hi all

I am using the formula =NETWORKDAYS(P2,S2) to calculate the time taken to process documents between the two dates P2 & S2. But if one of the cells is blank as we have not yet processed the document, I get huge random (it seems) results. Either positive or negative numbers in the thousands

How can I change it so that the result is blank or 0 if one of the dates is missing. (Not yet completed)?

Thanks

[Jonmo1]

Try

=IF(COUNT(P2,S2)=2,NETWORKDAYS(P2,S2),"")