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
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