Hi Pete,

Thank you for getting back, ill try to reply being as clear as possible.

1. I originally converted the raw data into a pivot table to calculate the totals for each day from Jan - Oct 2020

2. No i don't need the actual date. Days of the week within in month will work for me.
If there is a 6th week with no data, that is fine. If you would like me to manually complete Jan so you get a better idea of what im after, i can do that.

3. If i understood correctly - i will go with the 'If there is a 6th week with no data, that is fine'

4. I would like 1 month by 12. The main reason being that i will be adding further information and calculations (ex: average for all Mondays, avg per week, etc)

5. I don't need the raw data on the same sheet. The only issue ill have if its set up to select the year is the additional calculations i will be working with later. So if it's just one sheet with all the months under each other it will be easier for me.

Also, i really don't expect you to do this for me, if you would help me with a month or 2 or explain how it's done, i will then complete it myself - i don't want to come across as lazy!

Appreciate your time with this!

Thanks.