You're welcome! And I hope you find some other useful tips in the book.

The formulas you showed in your message would help if you needed to show
months and week numbers at the same time. My method wouldn't do that.

Gary L Brown wrote:
Thanks Debra!!!!!!!!!!!
That's great. I've learned a new one today.
Just checked your website. Good luck on your new book "Excel PivotTables
Recipes". You obviously know your pivot tables :O.
It's coming out March 6th? Count me in.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html