Networkdays Ignore if Two Cells are Blank

Hi,

In column Y, I want a calculation of workdays from a date if Column X is blank (ignore if a date has been entered). So far for this is what I have:

=IF(X2=0,NETWORKDAYS(T2,U2,Holidays_11_12),"")

This is working well however I have encountered an issue where in some cases a date hasn't been entered into Column S and Column Y is returning a Value Error.

Is there a way I can return a result in Column X and ignore when both Column S & Y are blank?

I want to use the value in X to determine conditional formatting in Column W to flag say green when it hits -10 days and change to red when it is greater than 0.

Cheers

Thanks for the reply...and sorry for sounding obtuse but could you break this down for me? I am not exactly sure how to proceed with applying this.

Thanks in advance.

Thanks, I needed simply..I have been staring far too long at this spreadsheet. Works perfectly! Your assistance if very, very much appreciated!