How do you restrict the weekend out of a Date/time column?

[Mitchell_Daly]

I am trying to make it so people filling out my form can’t choose the weekend for a drop off. I have tried the expression
[Barrel Drop Off Date/Time] is Weekday

Any ideas on how i can make this work?

[LeventK]

@Mitchell_Daly
Your syntax is not correct. Have you checked this page?

help.appsheet.com

WEEKDAY()

Day of week from Date or DateTime

[Mitchell_Daly]

I’ve gone over that info, but I am still not sure how to restrict the column to just Monday through Friday. Am I missing it?

[Steve · Accepted solution]

In Valid if:

NOT(
  IN(
    WEEKDAY([Barrel Drop Off Date/Time]),
    LIST(1, 7)
  )
)

[Mitchell_Daly]

This worked perfect for what I was looking for. Thanks!

[Heino_Matthee]

IN(WEEKDAY([Barrel Drop Off Date/Time]), LIST(2,3,4,5,6))