Working Days

craigleech

Hello,

I am trying to set conditional formatting to highlight due date cells when it is within 3 working days, however the sheet counts Saturday and Sunday as days.

Is there anyway of setting the sheet so saturday & sunday do not count as days?

Paul Newcome

You may need to use a WORKDAY or NETWORKDAYS formula somewhere. You could put it in a hidden column or use it to drive a RYG column and base your conditional formatting off of that.

craigleech

Thanks very much. I will look at this on Monday, have a great weekend.

 

Thanks again