Table of Contents
Grouping data by week in Google Sheets can be done by using the WEEK function. This function will take in a date and assign it to a corresponding week number. To group data by week, simply add a column to the data set, enter the WEEK function in the first row, and then drag the formula down to the rest of the column. The data will then be grouped according to the week numbers.
Often you may want to group data by week in Google Sheets.
Fortunately this is easy to do using the WEEKNUM() function.
The following step-by-step example shows how to use this function to group data by week in Google Sheets.
Related:
Step 1: Create the Data
First, let’s create a dataset that shows the total sales made by some company on various days:
Step 2: Create Week Variable
To extract the week of the year from the Date column, we can use the WEEKNUM() function to return a value between 1 and 53.
We can type in the following formula in cell C2:
=WEEKNUM(A2)
We can then copy and paste this formula down to the remaining cells in column C:
Step 3: Create a Pivot Table
Lastly, we can create a pivot table to find the sum of sales made each week.
To create a pivot table, highlight the cells in the range B1:C11 and then click the Insert tab along the top ribbon and click Pivot table.
In the Pivot table editor on the right side of the screen, choose Week for the Rows and Sales for the Values:
The values in the pivot table will now be filled in.
From the pivot table we can see:
- The total sales made during week 2 were 37.
- The total sales made during week 3 were 65.
- The total sales made during week 4 were 62.
We can also see that the grand total of sales made was 164.
The following tutorials explain how to perform other common operations in Google Sheets: