mercredi 25 mars 2015

Column Validation for day Monday OR Friday

I'm working with a date and time column and need a validation that returns true if the day of the week is Monday OR Friday. Users are not permitted to add an item on any other day of the week.

=TEXT([Date & Time],"dddd")="Monday"

This formula works perfectly for allowing only dates that are a Monday, I just need to add Friday into the same validator.

Sharepoint 2010

Any suggestions are greatly appreciated.

0 commentaires:

Enregistrer un commentaire