Please help....Date Format issue

[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

 

[Luke M]

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.