CF Saturdays Sundays and Holidays

Hi,

I have all the dates of the year in B1:NB1.

What formula do I use in CF to highlight the columns where the dates are either a Saturday or Sunday or its a public holiday from my table named holidays

Thanks
Kevin

=OR(WEEKDAY(A$1,2)>5,ISNUMBER(MATCH(A$1,_pr,)))

Thank you tim201110!

I think is suffice in CF this formula:

=WEEKDAY(A$1,2)>5

or

=WEEKDAY(A$1)>5

depending of regional settings.

=WEEKDAY(A$1,2)>5 will not return public holidays, but thanks for looking

I did not read carefully. Create a dynamic range name with holidays and then use:

=OR(A$1=holiday) if you want different color for holiday.

=OR(WEEKDAY(A$1,2)>5, A$1=holiday) if you want same color for weekend and holiday.