You can use a dynamic array formula to calculate weekly averages in Excel without relying on helper columns.