Using conditinal formatting to highlight weekends on Monday

[cochrajl]

Keep in mind that I know how to use the WEEKDAY formula to detect weekend days.

Here is the issue though...I run a report every day and I have conditional formatting set to highlight the current day and the previous day. How would I use conditional formatting to highlight the weekend days and the current day just on Monday. My current setup will get Sunday since it will be the previous day, but how would I get it to catch Saturday as well?

 

[cochrajl]

Anyone have any ideas on how to do this? Its mind boggling to me.

 

[cochrajl]

So far this is what I have, but it highlights all weekend days on Monday. I need it to highlight the previous weekend days on Monday.
=AND(WEEKDAY(TODAY())=2,WEEKDAY($H1,2)>5)

 

[barry houdini]

Try this version

=AND(WEEKDAY(TODAY())=2,$H1<=TODAY(),$H1>=TODAY()-2)

 

[cochrajl]

Try this version

=AND(WEEKDAY(TODAY())=2,$H1<=TODAY(),$H1>=TODAY()-2)

That works great! Thanks.