Filter List View by Current Week

If you want to be able to filter the list to only show items where “Date” is this week,

Most common option that appears first is to filter for the last seven days, using a calculated column for [Date]+7 with formula like

=DATE(YEAR([Created]),MONTH([Created]),DAY([Created])+7)

and filtering the view where this new calculated column is >=[Today]

But it is really last 7 days not the week period. I.e. If today is Wednesday, view should display items from Monday to upcoming Sunday (actual current week)

For this solution replace the <<Date>> with appropriate DateTime field base on which you want to filter the view.

  1. Create a calculated column named WeekStart returning type DateTime, with the calculation:

    =IF(TEXT(WEEKDAY(<<Date>>),”ddd”)=”Mon”,<<Date>>,IF(TEXT(WEEKDAY(<<Date>>-1),”ddd”)=”Mon”,<<Date>>-,IF(TEXT(WEEKDAY(<<Date>>-2),”ddd”)=”Mon”,<<Date>>-2,IF(TEXT(WEEKDAY(<<Date>>-3),”ddd”)=”Mon”,<<Date>>-3,IF(TEXT(WEEKDAY(<<Date>>-4),”ddd”)=”Mon”,<<Date>>-4,IF(TEXT(WEEKDAY(<<Date>>-5),”ddd”)=”Mon”,<<Date>>-,<<Date>>-6))))))

  2. Create a calculated column named WeekEnd returning type <<Date>>time, with the calculation: =IF(TEXT(WEEKDAY(<<Date>>),”ddd”)=”Sun”,<<Date>>,IF(TEXT(WEEKDAY(<<Date>>+1),”ddd”)=”Sun”,<<Date>>+1,IF(TEXT(WEEKDAY(<<Date>>+2),”ddd”)=”Sun”,<<Date>>+2,IF(TEXT(WEEKDAY(<<Date>>+3),”ddd”)=”Sun”,<<Date>>+3,IF(TEXT(WEEKDAY(<<Date>>+4),”ddd”)=”Sun”,<<Date>>+4,IF(TEXT(WEEKDAY(<<Date>>+5),”ddd”)=”Sun”,<<Date>>+5,<<Date>>+6))))))
  3. Create a view with the following filter:

    Column: WeekStart <= [Today] AND WeekEnd >= [Today]