Convert daily data set into weekly data set

Hi Guys,

I need to convert a simple but fair large data set that has daily row counts into a weekly row count pivot/table.

I don't have access to any add ons or anything, just good old Excel.

The data is a table of sites (columns) and dates (days) (rows). The data has been pulled from another system via VBA coding. It simply returns a value of 1 when the criteria has been met, for each day, for each site, and does nothing if the criteria has not been met. (blank).

I need to summarise this data into weekly summaries from 2018. It's hard to explain the table so please see attached example.

Many thanks in advance.