AnsweredAssumed Answered

Return the Monday of the week

Question asked by KurtSnow on Mar 17, 2015
Latest reply on Mar 17, 2015 by KurtSnow

Title

Return the Monday of the week

Post

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?

Outcomes