Quick If/Then problem

[Riot]

I am trying to create a formula that tells me if the day of the week is Fri, Sat Sun not. Here is what I am using: 

IF Contains([DayOfWeek],"Friday","Saturday","Sunday")
THEN 1
ELSE 0
ENDIF

But that isnt right. Anybody know how to fix it?

[MarqueeCrew · Accepted solution]

IIF([dayofweek] IN ("Friday", "Saturday", "Sunday"),1,0)

[chris_love · Accepted solution]

Try something like this:

If contains([DayoftheWeek],"Friday") or contains([DayoftheWeek],"Saturday")
or contains([DayoftheWeek],"Subday")
Then 1
Else 0
Endif

[MarqueeCrew]

Welcome back Chris!

[GarthM]

there's also this:

Switch(DateTimeFormat([dayofweek], '%A'), 0,
'Friday', 1,
'Saturday', 1,
'Sunday', 1
)