+ 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!
Lisitha reddy Lakkireddy 4Lisitha reddy Lakkireddy 4
I want the selected day to be restricted to Wednesdays
Also, I have to write a workflow to autopopulate Second wednesday from today() on a stage change @deepakgulian