Return the Monday of the week
I need to create a field that returns Monday's date of the current week. I used this formula:
date - DayOfWeek (date) + 2
which works fine, except for one problem. In my industry the week is defined as Monday - Sunday. The function works correctly for any date Monday - Saturday, but if the date is a Sunday it returns the Monday of the next week. Any way to get around this problem?