Multiple dates in an enum list column

[alhazen]

Hello, community,

Is it possible to get the sequence of dates that are multiples of 7 within this month's range by using a formula? Let's take August 7, 2023, as the starting date. This means I should get the next dates, which are August 14, 2023, August 21, 2023, and August 28, 2023, in a column.

Thank you for your help.

[Suvrutt_Gurjar]

Please try 

LIST(

IFS(MONTH([Start Date]+7)=MONTH([Start Date]), [Start Date]+7),
IFS(MONTH([Start Date]+14)=MONTH([Start Date]), [Start Date]+14),
IFS(MONTH([Start Date]+21)=MONTH([Start Date]), [Start Date]+21),
IFS(MONTH([Start Date]+28)=MONTH([Start Date]), [Start Date]+28)

       )-LIST("")

[alhazen]

Thank you, Sir, it works properly!