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 \\\|/// Blessed Day
(o o)
---oOO-(_)-OOo---

But as for me, I watch in hope
for the LORD, I wait for God my
Savior; My God will hear me.
(Micah 7:7)