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.

Solved Solved
0 3 344
1 ACCEPTED SOLUTION

@Tritonos_Gruppen

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

View solution in original post

3 REPLIES 3

@Tritonos_Gruppen

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

Thanks @LeventK

Youโ€™re welcome @Tritonos_Gruppen

Top Labels in this Space