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.
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:
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.
Next, we’ll choose to insert the pivot table in the current worksheet in cell E1 and click Create:
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: