Find weekend days

AppSheet AppSheet Q&A
1

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.

2

@Tritonos_Gruppen

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

Thanks @LeventK

4

You’re welcome @Tritonos_Gruppen