Is there a way to set up a date column to ONLY allow Monday dates?

[Lalit_Datta]

For example, in the column, today’s date, 03/16/2021 or any other day the rest of this week wouldn’t be valid entries, BUT 03/15/2021 or 03/22/2021 would be. Is there a way to make this possible?

[Steve · Accepted solution]

In Valid If:

(WEEKDAY([_THIS]) = 2)

See also:

help.appsheet.com

Valid_If Column Constraint

How to check if a given form input is valid based on its type.

help.appsheet.com

WEEKDAY()

Day of week from Date or DateTime

[Lalit_Datta]

Steve:

(WEEKDAY([_THIS]) = 2)

Exactly what I needed. Thank you so much!