Pivot table dates not times
 

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

Pivot table dates not times
 

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

Pivot table dates not times
 

"DaveO" wrote in message
...
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

Pivot table dates not times
 

S'ok sorted it

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



--
Vass

Pivot table dates not times
 

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

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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html