Grouping Data in a Pivot Table

Hi,

I recently got help from the Forum on building a macro and was kindly told that a Pivot Table would do the job better, which it does.

However, my table has a column of several dates, I was wondering the best way to group the dates into months rather than showing the full date, eg, September instead of 16/09/08 or August instead of 01/08/08.

I hope I have enough detail, if not please let me know and I can provide more info.

Thanks in advance for any help you can give.

Right click on the dates column and choose group

This will not work with blank cells.