Thread: Week commencing Date

Hi, im trying to write a formula to show week commencing in a field

e.g CELL A1 = 13/06/2011 08:48
so i need CELL B1 = 13th June

so i have =H2-WEEKDAY(H2)+2, however when i pivot the data it shows multiple rows for the same date, i am assuming this is because the time is in there?

Thanks

Amar