Conditional Formatting - Skipping Weekends

I want to create a conditional format that skips the weekend.

Example - Project is due within 2 business days it turns the cell box green.

Sample with me using the Today()+1 and Today()+2 Function

ExcelSS.jpg


Any help would be greatly appreciated!

Thanks

R

Originally Posted by sweep

Hi,

Try this formula to activate your conditional formatting

=AND(NOT(ISBLANK(A1)),NETWORKDAYS(TODAY(),A1)<=2)

Thank you for the post but I receive the following when I entered the formula listed above into the Conditional Formatting:

You may not use references to other worksheets or workbooks for Conditional Formatting criteria.