Conditional formatting excluding weekends

[dmhotep]

Well, my search has come to an end, I have found many "skip weekends" and count the next day (Monday if it is Friday), but what I am looking to do is highlight the next workday (Monday through Friday), but come Thursday, highlight both Friday AND Monday.

This works well to highlight the next workday, but how do I extend it to the following Monday as well?

=IF(TODAY()+1=WORKDAY(D1,0,2),TODAY()+1,"")

 

[Toadstool]

Try =OR(AND(WEEKDAY(D1,2)<6,D1=TODAY()+1),AND(WEEKDAY(D1,2)=1,D1=TODAY()+4))

 

[dmhotep]

Thank you Toadstool! I was getting closer to a solution until frustration set in. I replaced today() with a date in a cell and ran it through, it works very well. Now I will study the solution and have an AhHa moment...

 

[Toadstool]

Glad I could help. Here's a short explanation.

Wrapped in an OR() because you want a TRUE to trigger the Conditional format if either:

WEEKDAY type 2 (Monday=1, Sunday=7) is less than 6 AND date is day after today
OR
WEEKDAY is Monday AND date is 4 days ago.

 

[dmhotep]

I changed it to =OR(AND(WEEKDAY(D1,2)<7,D1=$I$11+1),AND(WEEKDAY(D1,2)=1,D1=$I$11+3)) which highlights Saturday and Monday if it's Friday! Very cool. I started down the AND(OR path at one point instead of the IF( I started with. This makes sense to me now. Thank you again.