Find weekend days

Hi

I am looking to highlight a row if the date is on a Saturday or Sunday.

WEEKDAY([Date])=1 or 7

Thought this was the way to go but does not seem to work. Could maybe use WORKDAYS()

Some help would be appreciated.

@Tritonos_Gruppen

OR(
	WEEKDAY([DATE])=1,
	WEEKDAY([DATE])=7
)
1 Like

Thanks :slight_smile: @LeventK

You’re welcome @Tritonos_Gruppen