Group A sharepoint List by Week
To Group a List by Week Number do the following:
- 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.
- 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. - Set the data type of the Calculated Column to Number with 0 decimal places
- Create the view that you want Grouped by Week.
- SORT the view by [Start Time] and GROUPBY the [WeekNumber] column.

Comments
Post a Comment