Grouping week category based on date

Dear community,

I have data as per screenshot below and would like to ask how can i convert the data to the result below:

Basically i would like to transform the column C and produce different result as per screenshot below.

Original

Output

Many thanks for the help.

Developer

Accepted answers

Here is my take on it.

Workflow:

Hope this helps : )

Here is how you can do it.

Workflow:

Hope this helps : )

Many thanks for the prompt response.

I would like to ask how can we create the formula to resolve the issue below if we have the sequence not in order.

Many thansk again for the help.

@SH_94
based on the flow of @atcodedog05 , I just added a sorting process.

Here is my take on it.

Workflow:

Hope this helps : )