Sorting in excel by week from oldest to newest?

Question

excel

Good afternoon.
Maybe someone faced such a problem. Pivot table. Grouping data by the date field with a period of 7 days.
It is necessary that the data in the table be sorted not by days of the week, but by weeks from old to new.
For some reason, Excel sorts by the first day of the week, which is incorrect.
I will be grateful for any help.
An example is available at https://cloud.mail.ru/public/7tKS/4d8aQXiFT
Thank you.

Answer 1

I propose the following (all formulas for the row with cell A2):
1. add the Day of the week column and write the formula =DAYWEEK(A2;2)
2. Add the Monday of the week column and write the formula: =A2-C2+1 (will return Monday of the week of the date from cells A2)
3. Make a pivot table on the column Monday of the week with a grouping of 7 days.
Profit_))))
The result is on the screen.