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