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