ExcelBanter - Pivot Table Dates Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Dates Question (https://www.excelbanter.com/excel-discussion-misc-queries/246839-pivot-table-dates-question.html)

Complibr

Pivot Table Dates Question

Is it possible to group dates in Excel by 6 weeks periods within quarters?
Thanks.

Jim Thomlinson

Pivot Table Dates Question

The short answer is no. In order to do that you need to add the necessary
time attributes to your source data. In this case which 6 week interval that
the record belongs to.
--
HTH...

Jim Thomlinson

"Complibr" wrote:

Is it possible to group dates in Excel by 6 weeks periods within quarters?
Thanks.

All times are GMT +1. The time now is 02:57 AM.