VB Code to summarize weekly Sales

Hello:

Please refer to attached file.

I have 2 sheets called Sales and Weekday.
As you can see Sales for Daily are shown in column L of Sheet "Sales".

I need a VB Code to summarize by Weeknum and day of the week as shown in "Weekday" Sheet.
Would need the Week Start Date and Weekend Date in column B and C.
I have manually completed for week 1
FY: My week start from Fri and ends on Thu.


Let me know if you have any questions.
Thanks.

Riz