| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping Date Fields in Pivot Table
I'm trying to summarise a member database using pivot tables in Excel 2003.
My source data includes a field for date of joining (dd/mm/yyyy). I would like to create a pivot table showing YEAR of joining as a variable and I'm sure it's possible to group individual dates into weeks or months or years, however I can't find how to make this happen. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grouping Date Data in a Pivot Table | Excel Worksheet Functions | |||
| Grouping Date Data in a Pivot Table | Excel Worksheet Functions | |||
| Grouping By Date in Pivot Table | Excel Worksheet Functions | |||
| Pivot table grouping of dates in row fields will not work. Why? | Excel Worksheet Functions | |||
| Pivot table-date grouping | Excel Discussion (Misc queries) | |||
Threaded Mode
