Display week in cell by date - help

[lpuname]

Hi

Can someone help on the below please

I've a "6/13/2011" in cell B3, in Cell A3, I want 06/13 to be displayed as this the starting of the week Monday, it should continue to display 06/13 until 06/19 which is Sunday.

[MarvinP]

Hi lpuname and welcome to the forum,

I think you can do this with a combination of the date and Weekday function. See the attached in Column B, I think this is what you want.

[Haseeb Avarakkan]

Hello Ipuname, Welcome to the forum!

Use in A3,

=B3-WEEKDAY(B3,3)

[lpuname]

Thanks Haseeb A!

Your formula worked.