Transforming Data from Daily to Weekly

First post. Hope you can help as kindly as the community always does!

Im trying to change some data from a daily basis to a weekly basis , but I realized that the amount of data is so big that doing it mannualy is going to take forever. I attach here an example of how i am doing it right now. As you can see the in the Weekly Sheet, the Sum(B1:B5) and the Sum(B6:B10) and so forth represent the addition of the week BEFORE so the green highlighted days are Mondays that are NOT included in the sum.
Is there any way i can automate this process? It is very time consuming. I want the sum to add all the value of the past week (M-F) and show it in a cell that represents the date as monday of the following week.To make it clear:

Date Daily Value / Weekly Transformation
Mo1 2 / Mo2 2+3+4+4+7
Tu1 3 / Mo3 9+5+2+3+4
We1 4
Th1 4
Fr1 7
Mo2 9
Tu2 5
We2 2
Th2 3
Fr2 4
Mo3 1

Any ideas? I attach the spreadsheet if I did not make my point clear, its pretty hard for me to explain it.
Thanks in advance guys!
Sample Daily to Weekly.xlsx

here are 2 ways to solve it

weekly contains the formula solution

wk contains the macro solution

Hope anyone can help, doing this manually takes hours.
To make it clear, the formula =SUM(B3:B7) follows a pattern that i can't just drag down because the pattern is NOT =SUM(B4:B8) but it's =SUM(B8:B12).
The correct pattern should look like this.
1.=SUM(B3:B7)
2.=SUM(B8:B12)
3.=SUM(B13:B17)
4.=SUM(B18:B22)

Notice that both numbers increase by 5 every time. Ideas?

Thank you ! I will study this method