shift rotation pattern

How do i get excel to report 12 week rotation for a data with date,?

In this sheet, we have added data into some rows

we need to get data in 12 week rotation pattern

How do i do this one?

Date and Day should match with calender and also the 12 week rotation pattern of data is what we are after.