2

I have a field in a custom list called "WeekOf". I have a default statement that populates the date as the following Monday, but some people are entering for future weeks and then add a start date other than a Monday.

What statement should I put in the column validation to require a Monday?

I'd just figure it out myself, but the client wants it fixed asap.

1
  • Do you want to allow only next Monday or any date which has day as monday? Aug 10, 2020 at 13:05

1 Answer 1

1

If you want your users to enter only future Monday's then try using below formula:

=IF(AND(TEXT(WEEKDAY([Date Column]), "dddd") = "Monday", [Date Column] > Today()), true, false)

If you want your users to enter current as well as future Monday's then try using below formula:

=IF(AND(TEXT(WEEKDAY([Date Column]), "dddd") = "Monday", [Date Column] >= Today()), true, false)

If you want your users to enter any Monday (Past, current or future) then use below formula:

=IF(TEXT(WEEKDAY([Forecast Release Date]), "dddd") = "Monday", true, false)
2
  • 2
    The third option worked perfectly when I entered it into the List Validation Settings and changed the column name to match. Thanks, Ganesh!
    – ahowes
    Aug 10, 2020 at 17:22
  • 1
    Great, Glad it worked for you. Please Upvote and accept it as an answer as it helped you. Aug 10, 2020 at 17:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.