Often you may want to group data by week in Excel.

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 Excel.

**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 **PivotTable**.

In the new window that appears, we’ll place the pivot table in cell **E2** of the existing worksheet:

Once we press **OK**, a PivotTable Fields panel will appear on the right side of the screen.

Drag the **Week **variable to the Rows box and the **Sales **variable to the Values box:

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**.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

How to Convert Days to Months in Excel

How to Count by Month in Excel

How to Filter Dates by Month in Excel