Conditional Format Day Formula (2000/2003)

Topic

New Reply

I have column B formatted as a date. I as using custom ‘ddd’. I want to highlight the current cell (that contains) the formula below,if it is equal to Sat or Sun.
I tried the following formula but it always returns false (because b9 is a date),
How can I change the formula to make it highlight the cell if the date, in b9, is equal to Sat or Sun.

=OR(B9=”Sat”,B9=”Sun”)

Reply | Quote

Replies

Try =WEEKDAY(B2,2)>5

Reply | Quote

That did the trick, thanks

Reply | Quote

The ddd format only determines how the cell is displayed on screen, the underlying value is still the complete date. Try this formula:

=WEEKDAY(B9,2)>5

The WEEKDAY function with second argument 2 returns 1 = Monday, 2 = Tuesday, … 7 = Sunday. So if the value is more than 5, it must be a Saturday or Sunday.

Reply | Quote

Good explanation I understand now. thanks

Reply | Quote