Group A sharepoint List by Week

To Group a List by Week Number do the following:
  1. Make sure the list has a column that contains the Date you wish to GroupBy. I'll use the Start Time column of a standard Event list but you can use any Date/Time column. You don't need to filter out the Time portion first, it will be ignored.
  2. Add a Calculated column to the list called 'WeekNumber' that uses the following formula:
    =INT(([Start Time]-DATE(2007,1,1))/7)
    where [Start Time] is the date column whose week you want to group by.
  3. Set the data type of the Calculated Column to Number with 0 decimal places
  4. Create the view that you want Grouped by Week.
  5. SORT the view by [Start Time] and GROUPBY the [WeekNumber] column.

Comments

Popular posts from this blog

Apply CSS styles to SharePoint Web parts

SharePoint Number Column Without Commas

Create Summary view of SQL Datatable