Plot week as a column in between Weekdays

[Parth007]

Dear Experts,

Please assist..

"RawData: Sheet have date wise columns (Anydates can be there Entire monthly, or 15 days or 10 days or 2 months dates etc ... anything)

We need to calculate the weeks in between these days.
Data comes only for Weekdays.

So sample output is shown in "Output" Sheet

In Output sheet Columns marked in Yellow should be populated on a button click, currently they are doen manually


Big Thank You