Incremental date increase by 7 days with autofill in formula

Greetings
I'm a somewhat new excel user. Almost zero formula knowledge.

I need the formula to increase the dates by 7 as I drag cell in a row.

Example:
=COUNTIFS('Schedule-TM'!$Y:$Y,">="&DATE(2022,12,12),'Schedule-TM'!$Y:$Y,"<="&DATE(2022,12,18))

=COUNTIFS('Schedule-TM'!$Y:$Y,">="&DATE(2022,12,19),'Schedule-TM'!$Y:$Y,"<="&DATE(2022,12,25))

=COUNTIFS('Schedule-TM'!$Y:$Y,">="&DATE(2022,12,26),'Schedule-TM'!$Y:$Y,"<="&DATE(2023,1,1))

In the attached file, on tab "Dates" in cell B3, I want the dates to increase by 7 days, and if possible, the formula needs to span into the next year. These dates can be found on the tab "Schedule".

I looked into using a table, that was a deep rabbit hole that led me to the land of confusion.