Hello.

I have column of data that is both date and time. However when I create the
pivot table I only want it to summarize the date.

I've formatted both the source and the pivot table to display on the date
but formatting doesn't affect the underlying data so if a date has three
different times, then the pivot table has three different entries for a given
date.

I can (and have) parsed out the serial number to remove the time portion but
that gets a bit time consuming and this comes up frequently in different
spreadsheets. I'm wondering if there's away to do it automatically, if
there's a function I'm missing?

Lori