Pivot table dates not times

[Vass]

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

 

[Guest]

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]

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}).

Nope, Excel is asking for year, month, day with that function

 

[Vass]

S'ok sorted it

=DAY(A16) & "/" & MONTH(A16) & "/" & YEAR(A16)

 

[Debra Dalgleish]

In the pivot table, right-click on the date field, and choose Group and
Show Detail>Group
From the list, select Days, click OK