After you create the pivottable, you can rightclick on the date/time field and
choose Group and show detail.

Then Group, then by Days.

Bob Gotti wrote:

I have a long spread sheet that has two columns of dates (Received and
Finished)
that I am importing into a pivot table and would like to use the dates in my
pivot,
less the time. For daily use, I do use the time with the date, but only
want the date
for use in the pivot table. How can I eliminate the time serial number,
before importing
into my pivot, apart from editing each individual cell?

Have a \\\I/// Blessed Day,
( o o )
--oOO-(_)-OOo-- Bob Gotti

--

Dave Peterson