{"id":24,"date":"2007-04-24T06:49:00","date_gmt":"2007-04-24T11:49:00","guid":{"rendered":"http:\/\/www.dontpapanic.com\/blog\/?p=24"},"modified":"2007-04-24T06:49:00","modified_gmt":"2007-04-24T11:49:00","slug":"group-a-list-by-week-number","status":"publish","type":"post","link":"https:\/\/www.dontpapanic.com\/blog\/?p=24","title":{"rendered":"Group A List by Week Number"},"content":{"rendered":"
\n
\n

I’ve seen several requests recently for how to Group a Sharepoint list by Month.  I’ve also seen several Blog posts on how to do it.  But recently I saw a query about how to Group by the Week Number of the year and several responses stating that it couldn’t be done.  I’ve always liked a good challenge, especially one that someone else says is IMPOSSIBLE.  So I decided ot figure out how to do it.  The results are below.<\/p>\n

To Group a List by Week Number do the following:<\/u><\/div>\n
<\/u> <\/div>\n
    \n
  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. <\/li>\n
  2. Add a Calculated column to the list called ‘WeekNumber’ that uses the following formula:
          =INT(([Start Time]-DATE(2007,1,1))\/7)
    <\/font>where [Start Time] is the date column whose week you want to group by. <\/li>\n
  3. Set the data type of the Calculated Column to Number with 0 decimal places <\/li>\n
  4. Create the view that you want Grouped by Week. <\/li>\n
  5. SORT the view by [Start Time] and GROUPBY the [WeekNumber] column. <\/li>\n<\/ol>\n

    You’ll get a view that looks something like this:<\/p>\n

    \"GroupBy\"<\/a><\/div>\n
     <\/div>\n
    This will give you a grouped list with the week number from the first day of the year.  But January 1st is rarely a Sunday or Monday.  If you want to be more accurate substitute the date of the first Sunday prior to 1\/1\/2007 in place of Date(2007,1,1).  This will give you the week number counting from the First partial week of the year.<\/div>\n
     <\/div>\n
    Of course you’ll need to redo the calculated column when January rolls around next year, but only to change the Calculated Column to point at the first day of next year.<\/div>\n
     <\/div>\n
     <\/div>\n<\/p><\/div>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

    I’ve seen several requests recently for how to Group a Sharepoint list by Month.  I’ve also seen several Blog posts on how to do it.  But recently I saw a query about how to Group by the Week Number of the year and several responses stating that it couldn’t be done.  I’ve always liked a … Continue reading Group A List by Week Number<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[17,15],"class_list":["post-24","post","type-post","status-publish","format-standard","hentry","category-sharepoint-2007-admin","tag-admin","tag-sharepoint_2007"],"_links":{"self":[{"href":"https:\/\/www.dontpapanic.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/24","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dontpapanic.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dontpapanic.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dontpapanic.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dontpapanic.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=24"}],"version-history":[{"count":0,"href":"https:\/\/www.dontpapanic.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/24\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dontpapanic.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=24"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dontpapanic.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=24"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dontpapanic.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=24"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}