AnsweredAssumed Answered

Return the Monday of the week

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


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?