display Monday week num in a cell - Help

lpuname

New member
Joined
Jun 13, 2011
Messages
1
Reaction score
0
Points
0
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.

 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,521
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
I'm assuming that B3 changes every day and you want to know the Monday from that week?

=B3+1-WEEKDAY(B3,2)

HTH,
 
Top