How to get excel 2010 pivot table custom date grouping?

I am trying to group a pivot table by the date rang  the 22nd to the 21st example...
Dec 22 – Jan 21 = Jan 2015
Jan 22 – Feb 21 = Feb 2015
Feb 22 – Mar 21 = Mar 2015
Mar 22 – Apr 21 = Apr 2015
Apr 22 – May 21 = May 2015
….etc….
Thanks,
Jimi
Jimi ShermanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ProfessorJimJamConnect With a Mentor Commented:
it is not possible with pivot table grouping but it is possible create grouped date with helper column and then pivot

see attached.
BOOK1V1.xlsb
0
 
Jimi ShermanAuthor Commented:
OK understand. Thanks for the formula that helped out a lot...I can make it work.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.