Code to speed up sumproduct formulas

tbeast,

Attached is a modified version of your posted workbook.
I updated all of the named range formulas.
I noticed that the ranges on the 'Data' sheet had some blank cells, so I based on the row count for all named ranges on 'Data' column A, so that they would all have the same row count as the named range "Dates". This was necessary because Sumproduct multiplies arrays together, and the arrays must have the same row count or the formula will return an error.

I also turned the calculation mode to automatic. Changing the week beginning or week ending sees the whole table on the 'Weekly' sheet get updated basically instantly.