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 |
