+ Start a Discussion
Beth KoehlBeth Koehl 

Validation rule to make selected Date a Monday

I am wanting to create a validation rule that forces the date selected by a user to be a Monday.  Any suggestions?
Best Answer chosen by Beth Koehl
Deepak GulianDeepak Gulian
MOD( Date_Field - DATE(1900, 1, 6), 7) <> 2
This is the formula for your validation rule, this formula will allow user to add a date whose day is monday only, else it will give error.

All Answers

Deepak GulianDeepak Gulian
MOD( Date_Field - DATE(1900, 1, 6), 7) <> 2
This is the formula for your validation rule, this formula will allow user to add a date whose day is monday only, else it will give error.
This was selected as the best answer
Beth KoehlBeth Koehl
Awesome, it works perfect!