Weekly Report Formula or Pivot Table?
See Mr Excel and excelisfun take daily transactional data and create Weekly Summary Reports using a Pivot Table (PivotTable) and a series of formulas.
1.Formula for first Monday in Week using DAY and WEEKDAY functions and DATE, MONTH and YEAR functions
2.Formula to create Text label for Chart using TEXT function, Custom Number Format and the join symbol, Ampersand.
3.Create a Weekly Chart without Chart Junk.
4.Keyboard shortcut for default chart on sheet: Alt + F1
5.Pivot Table Grouped by Week
6.Line Chart and Column Chart for Weekly data