List of dates into weekly brackets

[h12]

Hi team

I am not sure if this can be done dynamically (that would be ideal) but I have a list of dates in a column and I would like them to automatically be bracketed into week periods (Monday to Sunday). Ideally, the week column is created automatically based on the date in the first column

2022-04-04

2022-04-04

2022-04-04

2022-04-05

2022-04-07

2022-04-11

2022-04-15

2022-04-26

2022-04-26

2022-04-30

2022-05-02

2022-05-03

Into:

2022-04-04	2022-04-04 - 2022-04-10
2022-04-04	2022-04-04 - 2022-04-10
2022-04-04	2022-04-04 - 2022-04-10
2022-04-05	2022-04-04 - 2022-04-10
2022-04-07	2022-04-04 - 2022-04-10
2022-04-13	2022-04-11 - 2022-04-17
2022-04-15	2022-04-11 - 2022-04-17
2022-04-26	2022-04-25 - 2022-05-01
2022-04-26	2022-04-25 - 2022-05-01
2022-04-30	2022-04-25 - 2022-05-01
2022-05-02	2022-05-02 - 2022-05-08
2022-05-03	2022-05-02 - 2022-05-08

[binu_acs · Accepted solution]

@h12 

[PhilipMannering · Accepted solution]

Hi @h12 

This should start you off,

[Qiu · Accepted solution]

@h12 
My results is somehow different with your desired output.
I use the formula below to calculate the weekend.

DateTimeAdd([Date],(7-tonumber(DateTimeFormat([Date],'%u'))),'Days')

[Qiu]

@PhilipMannering 
We are same on the calculating the weekend. 😁

[h12]

Thank you @binu_acs , @PhilipMannering and @Qiu! The above was very helpful!

[Qiu]

@h12 
Thank you for the feedback and glad to be helpful.