Create an interval of date

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.