How To UPDATE from a SELECT in SQL Server?

Date range offset

I want to generate a array's date offset

for e.g:

input :

dayjs()

Output :

["16/08/2022","23/08/2022","30/08/2022","6/09/2022"]

as you can see dates are offset (weeks) , I have no idea how to implement this

Any hints please ?