2 Replies Latest reply on Mar 17, 2015 2:49 PM by KurtSnow

    Return the Monday of the week

    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?