ExcelBanter - grouping mass date data

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

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

- - grouping mass date data (https://www.excelbanter.com/excel-discussion-misc-queries/60770-grouping-mass-date-data.html)

jaylo

grouping mass date data

I am trying to group some data, at the moment its pullin the info as
individual dates but i need them to be in some sort of group ie.
months/weeks. Ive tryed to group via the field but its says i can group it
that way. Any ideas ? ie.

Peo Sjoblom

grouping mass date data

You can group dates using a pivot table

--

Regards,

Peo Sjoblom

"jaylo" wrote in message
...
I am trying to group some data, at the moment its pullin the info as
individual dates but i need them to be in some sort of group ie.
months/weeks. Ive tryed to group via the field but its says i can group
it
that way. Any ideas ? ie.

All times are GMT +1. The time now is 09:01 PM.