After you create the pivottable, you can:

rightclick on the date/time header.
Choose Group and Show Detail
Then choose Group
and group by Days
(unselect any other options)



Or you could do this:
Insert another column with just the date:
=int(a2)
and format it as a date.

And then pivot on that extra helper column.



Seede wrote:

hello
the data in my spreadsheet is with datetime. when i create a pivot table, it
creats multiple rows for data with same date.
when i tried to change the format, it did not help
how can i create a pivot table that does not create multiple rows for data
with sme date when my souce excel data is in datetime.

--

Dave Peterson