Highlighting Weekend for Random/Repeated dates

[pvkvimalan]

Hi,
I have a dataset where "Column B" contains dates that are repeating, missing, or random. I want to highlight the weekends for these dates. I have used formulas such as "=OR(WEEKDAY(C5)=7,WEEKDAY(C5)=1)" and "=WEEKDAY(B2,2)>5" but was not able to get the desired results. Need help in finding a solution.

 

[James006]

Hi,
You could test

=WEEKDAY(B2,2)>=6

 

[pvkvimalan]

Hi,
You could test

=WEEKDAY(B2,2)>=6

Hi James,
Wonder how I missed this formula. Thanks, it worked like a charm.