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?
Solved! Go to Solution.
Welcome back Chris!
there's also this:
Switch(DateTimeFormat([dayofweek], '%A'), 0,
'Friday', 1,
'Saturday', 1,
'Sunday', 1
)