Quick If/Then problem

Question

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 Answer

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

chris_love · Accepted Answer

Try something like this:

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