generate a list of dates

[alhazen]

Hello Community,

Is it possible to generate a list of dates with a weekly frequency for the next 5-month period? I am using the following formula, but it doesn't seem to be efficient.

LIST(

 IFS(

  [frequency]="Weekly",

    MAX(

      SELECT(

        overhead[date],

          AND(

            [control]=[_THISROW].[id],

              [position]="Predictive"

            )

         

            

        )

      )+7

  ),

  IFS(

  [frequency]="Weekly",

    MAX(

      SELECT(

        overhead[date],

          AND(

            [control]=[_THISROW].[id],

              [position]="Predictive"

            )

         

            

        )

      )+14

  )

)-LIST("")

 Thank you so much for your help 

[AleksiAlkio]

One way is to have a table (Dates) for that purpose. Another way is to generate a dynamic list like..
LIST(TODAY(),TODAY()+7,TODAY()+14,..) or for Mondays like.. LIST(EOWEEK(TODAY())+2,EOWEEK(TODAY())+9,..)