Group date in Privot table - VBA

[laihung8]

Hi all,

I am looking for a VBA code that I can group the date. As the table have two different types of data, July and 7/1/2011. Because July was not type in as number, so the Pivottable doesn't allow me to group it. Can I get a VBA code to solve this issue? Many thanks in advance and looking forward for your prompt respond.

Thx.
Laihung8

 

[Peter_SSs]

Duplicate to this thread

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

In future please post any clarifications, or follow-ups in your original thread rather than starting a new one.