I have a worksheet with date and time all in one cell
i.e. 12/05/2006 15:32:36

I want to pivot table all similar dates together
i.e. all occurrences of 12/05/2006 regardless of the time

How do I do this please?
ta

--
Vass