Showcasing the week of a date

I have a date coming in a cell say 15th September in B1 cell. And in C1 cell I want to show that particular week detail, i.e., "14-20th September" week.

How can I bring it..

Regards
Harvinder

Not exactly a solution, but perhaps this example can give you or others on the forum something to work with.

Hi. My be it helps

Formula:

Please Login or Register  to view this content.

or, for weeks in 2 month:

Formula:

Please Login or Register  to view this content.