Issues Creating Weekly Summary Totals

>The issue is unable to workout creating summary weekly totals and finding the right way and /or formula to bring them to sheet 2.

I am creating an official tax log for my first year as a 1099 employee using my handwritten log from the year.

I created sheet 1 with column A1 labeled for dates. Further down on column O is labeled total earnings.

The problem I’m running into researching, using copilot, google search, YouTube, etc., is every formula or different step I have attempted is unable to move the dates into a week-week type row (week 1, week 2) in order to give the weekly totals next to it I believe for 2 reasons.

1- my starting work date is on 2/14/2025 ending on 12/29/2025. Along with trying to align it with my workweek which would make 3 days for week 1(2/14-2/16) and then follow the 7 day formula for the rest.

2- I started off my entire sheet using copilot assist from someone else account at home and I think with the way AI set up my formulas in the sheet, it is causing issues and errors. His subscription had cancelled after the second day I was working on the tax spreadsheet.

***last thing I attempted: opened sheet 2 and labeled a1 start date/ b1 end date/ week numbers.

Then I manually filled in week 1 and week 2. I then found a formula to allow me to fill in the rest of those columns. But now I am stuck on the original issue of still not finding the right formula to bring the weekly totals from sheet one over to sheet two.

— not sure if important but I’m working on system 1 date system.

Thank you for any feedback!