Create an interval of date

Olivier_Maltais 

This is the changed workbook showing both Riny_van_Eekelen 's formula and my function.

I had to change the {0,6} to {0;6} (row to column) but also concatenate the dates by column.

Olivier_Maltais 

This takes Riny_van_Eekelen 's formula a step or two further, for better or worse!

I finished with the worksheet formula

= Weeksλ(baseDate, 26)

where Weeksλ is a Lambda function that returns one week intervals as text, here starting with 'baseDate' and returning 26 weeks.  The function executes the steps

Weeksλ
= LET(
    intervals, SEQUENCE(count, , base, 7) + {0, 6},
    week,      TEXT(intervals, "yyyy/mm/dd"),
    BYROW(week, Concatλ)
  )

Adding {0, 6} to the week starting dates spills dynamically to give start and end dates for each week.  The TEXT function is applied to each date, returning dates in international format.  BYROW takes the dates in pairs and concatenates them using Concatλ to insert the time interval using the preposition 'to' as the separator,

Concatλ
= TEXTJOIN(" to ", , w)

Of course, all this requires Excel 365.

Olivier_Maltais If you are on a modern version of Excel you can use the formula below as demonstrated in the attached file.

=TEXT(SEQUENCE(52,,A1,7),"yyyy/mm/dd") & " to " & TEXT(SEQUENCE(52,,A1+6,7),"yyyy/mm/dd")

where A1 contains the first day of the sequence (in your case 2023/12/31).