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.

Thanks Bernie

Not exactly. I need to provide you more info.
I need to count dates in column A based on date ranges according to a calendar that numbers each work week.
Example, work week 50 is "Dec 12 2022 thru Dec 18 2022".

When I drag cell B3 one cell to the right I need the date to change to reflect "Dec 19 2022 thru Dec 25 2022" (work week 51).
Drag again and the formula changes to show "Dec 26 2022 thru Jan 01 2023"

I saw a google post about something similar where they attempted to use a table (pivot) but my eyes glazed over.

Thanks and I hope I explained this correctly.

Don

Good morning

My bad. Your formula works exactly as I need it to. I was expecting to see the dates change in the formula bar, base
on how I had originally created my formula.
Your help has saved me hours of manually inputting in the dates because my master forecast schedule goes out several years.

Thanks again Bernie