Wanting to build a check total sheet that references a dynamic calendar

I am going to try and Make this as clear as possible but it might be a bit confusing.

I am creating a Dynamic Calendar (which it is created and works it seems) to track my work schedule. I work a two week on two week off schedule and I change out on Thursdays. I got it formatted to shade my schedule where I’m at work(not important) and shaded to add extra weeks.

I want to create a second sheet that tracks the weeks of work (actually pay periods but both.)

Listed as Back, Full and Front

Back- is the first week I’m at work

Full- well that’s a full week

Front- last week or the front half

I want column A to be the work week but started on a Monday and the pay period would be the following Friday in column B. Column C would list the type of week and D would be the amount associated with the type of week.

My calendar is a grid 3x4 months. from empty first Jan square is B5 and all the way to X37 there is columns and rows spacing each month out

In AA4 is the year

AA5 is rotation start date

AA6&AA7 is days on and off.

I have tried using AI I have tried getting it to reference and when I get close the column for Week type does not fill correctly or won’t add an extra week when adding to that boxes or it adds every week possible in the year.

I hope that was clear I been messing with it like a day before asking AI. And nothing I do gets it.

Either it fills all weeks at full or no full weeks.