Date/Time issue with Pivot Table

[Lori]

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

 

[Ed Ferrero]

Hi Lori,

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.

Right-click the date-time field and choose the Group... menu item.

Ed Ferrero
www.edferrero.com

 

[Herbert Seidenberg]

Group > Days

 

[Lori]

Dear Ed,

When I right click on the date/time field in the pivot table I get the
option for group, but does this process mean I have go through and manually
group all the dates but it will only group selections.

Or am I supposed to create the groups in the main spreadsheet because I have
a variety of date/time columns...

Lori