Count Days Between Dates or Leave Blank

[scott11]

Hello,

I currently have the following formula in cell D13: =NETWORKDAYS(E13,F13) but I am receiving a value error because I have formulas in cells E13 & F13 that are not currently populated, as shown below. How can I return either a zero or a blank cell until those two cells contain data?

=IF(MIN(E14:E18)>0,MIN(E14:E18),"") Cell E13
=IF(MAX(F14:F18)>0,MAX(F14:F18),"") Cell F13

 

[Fluff]

How about

=if(or(E13="",F13=""),"",NETWORKDAYS(E13,F13))

 

[scott11]

How about

=if(or(E13="",F13=""),"",NETWORKDAYS(E13,F13))

That worked, thanks Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.