How Do I Eliminate the Serial Number for time from Date?

[Guest]

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

 

[Pete]

Dates are stored as whole numbers (days elapsed since the reference
date), whereas times are stored as fractions of a 24 hour day. So, you
can get the date part by

=INT(A1)

if A1 holds your date/time combination. Format as required, then the
formula can be copied down.

Hope this helps.

Pete

 

[Dave Peterson]

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

Then Group, then by Days.