ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   PivotTable Groupind (https://www.excelbanter.com/excel-discussion-misc-queries/997-pivottable-groupind.html)

tjtjjtjt

PivotTable Groupind
 
When using real dates, is it possible to group months together in any way
other than the calendar year?
I can do this easily enough when the dates are identified with the actual
words January, February, etc. But, this forces me to have an extra field in
my list. I would prefer to just dates: 1/1/2004,2/15/2004, etc. and group
them into the necessary quarters. Q1 would be 2-1-04 to 4-30-04, for instance.
--
tj


All times are GMT +1. The time now is 08:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com