IF/ OR Formula not working?

[pete4monc]

Hi all
I have tried different versions of the excel formula and can not seem to get the right result.
Column H = Date in, Column I = Date completed,
If there is no completed date Column I, Column L = Days that the department has had the file less the weekends and holidays.

=IF(OR(H5="",I5=""),NETWORKDAYS(H5,TODAY(),'Holiday List'!$B$2:$B$23),"")

Only first date entered= Column L shows number of days = good
Both dates entered= Column L shows blank = good
No dates entered = Column L shows 31847 = bad.

How do I get the cell in column L to show nothing if there is no dates entered into either Column H or Column I?

Thank you for any advice.

 

[Eric W]

Try:

=IF(COUNT(H5:I5)=1,NETWORKDAYS(H5,TODAY(),'Holiday List'!$B$2:$B$23),"")

 

[pete4monc]

Try:

=IF(COUNT(H5:I5)=1,NETWORKDAYS(H5,TODAY(),'Holiday List'!$B$2:$B$23),"")

Hi Eric

Thanks for your help, I'm still new to excel and formulas and I didn't even consider "count" version.
It worked a treat, thanks for your help.

 

[Eric W]

Excel always has more to learn! Glad I could help and thanks for the update. ?