DayOfWeek ( Date )
will return a value of 2 for a date that falls on a Monday.
You might want to make an entered date auto-correct to be Monday of the same week:
Self - DayOfWeek ( Self ) + 2 // clear the "do not replace existing value..." check box
Thanks for the response Phil, but Im having an issue. I like the the Idea of using the auto correct you mentioned. I can't seem to get it to work. Here is what I am doing.
I have a field called " Start Date" this is a Date Field.
I went under options to Validation.
I checked "Validated by calculation"
I type in:
Self - DayOfWeek ( Self ) + 2
What am I doing wrong?
It's not a validation calculation. It's an auto-enter calculation.
Copy this calc to the clipboard and then remove it.
Click the auto-enter calc.
Click the calculation button.
Paste the copied expression there.
Clear the "do not replace existing value..." check box.
Thank you!! Works great.