Pivot table dates not times

V

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
 
D

DaveO

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.
 
V

Vass

DaveO said:
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}).
Click to expand...

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

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
 
Top