Please help....Date Format issue

  • Thread starter Thread starter SandyW
  • Start date Start date
S

SandyW

Hi,
I produce pivot tables that detail time worked by month but I receive the
information in the following date format: 01/10/08, 02/10/08 etc. I want to
be able to format the date so that the name of the month appears (prior to
running the pivot) i.e OCT.
I have tried using custom formatting i.e MMM which is OK but when I run the
pivot the individual days still appear in separate columns and not just the
total for OCT in one column.

Please can anyone help.

Thanks
Sandy
 
You'll need another column in your data (creating another field for your
PivotTable)
Assuming dates are in column A
=MONTH(A2)
copy down, format as "mmm". Remember to give this column a label (Month)

You now use the Month field in your Pivot Table.

NOTE: Based on what you said, no distinction is made between years. All of
1/08 data would be grouped with 1/09 data.
 
Back
Top