The quickest way would be to create another field at the end of your date,
call it date and then set the cells =Date({cell with date in it}).

HTH.

"Vass" wrote:

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