conditional formula needed

[ruthm8611]

I have two dates: I want the cell where the second date is entered to turn color when the first date goes past one workday. I currently have the formula =$E3+1 which works fine until the weekend. How can I use the conditional format and only count weekdays? Thank you in advance for any assistance.

 

[Andrew Poulsom]

See if you can adapt the example here:

http://www.mrexcel.com/forum/showthread.php?p=2788055