Going to the next level after using IF(NETWORKDAYS...) to make crazy numbers blank

Hi everyone,

I hope someone can help me with their expertise.... I have just got the hang of using NETWORKDAYS function along with the IF function, so that if there are no dates then the cell will come out blank. My issue is if only one of the two dates required are missing, the resulting number in the final cell comes out to be 30,000ish if the first date is missing, and to-30,000ish if the second date is missing (fair enough, as I am still gathering the data!)

Is there a way of hiding those +/-30,000 numbers because they are messing up the rest of the spreadsheet?! I would just like it to come out blank. I am guessing I need another IF clause in there, but not sure how it fits into the formula... I am guessing I need something along the lines of IF(xxxx>30000,"",yyyyy) but not sure what the xxxx and yyyy values need to be.... (or there is an easier way?!)

To put into context, I have the following data:

C column has starting date
S column has completion date
T column has the number of business days between the two, which has the following formula in it:

=IF(NETWORKDAYS(C5,S5)=0,"",(NETWORKDAYS(C5,S5)))

I hope that makes sense - can anyone please help me??

Thanks.

Try

=IF(COUNT(C5,S5)=2,IF(NETWORKDAYS(C5,S5)=0,"",(NETWORKDAYS(C5,S5))),"")

Wowsers, it works! Thank you!

Can I ask, where does the 2 come from? is that a "if there are 2 data points" in the formula, then keep going?

Count returns the count of Numeric Values in the referenced ranges (C5 and S5)

So if the count is 2 (meaning both cells have a date in them), then do the network days formula, otherwise return ""

OK Great, thank you so much....

#Solved

You're welcome.