But what if your boss wanted all of the weeks to start on a Monday? Last time we learned about Excel Group by Week using Pivot Tables. Let’s dive into this method and see how it works. You can also use the group selection feature in Pivot Tables to Excel group by week.

This will provide you with a Weekly Sales Report in Excel using the Weeknum formula. STEP 7: Drag and drop Week Num in the Row field and Sales in the Values field. STEP 6: In the Create PivotTable dialog box, Click OK.

To combine year and week num, use the formula: =G2&”-“&WEEKNUM(E2,1) Week number should be combined with the year to provide accurate results. STEP 3:This report contains multiple years. By default, Excel will consider that the week will begin from Sunday. It will simply return the week number of a specified date. STEP 1:Create a new helper column that will provide the week numbers for the dates. In the screenshot below, you have sales data for a company for which you need to create a weekly report.