| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Months / Dates in Pivot Tables
Hi,
I have a PT with about 300 records, each record has a date in the format dd/mm/yyyy - how do I get my PT to group dates into months so that I can either count or sum the records created within a month - I think I need to group them somehow but can't see how I do this. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates And Pivot Tables | Excel Worksheet Functions | |||
| Pivot tables and dates | Excel Worksheet Functions | |||
| Grouping DATES in a pivot tables | Excel Discussion (Misc queries) | |||
| Pivot tables with pre-counted dates | Charts and Charting in Excel | |||
| Using dates as data in Pivot Tables | Excel Worksheet Functions | |||
Linear Mode
