| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping Dates by Month
If your dates are recognized as dates by Excel, a pivot table will do this
and lots more in no time. HTH. Best wishes Harald "Need Letters in the Columns" skrev i melding ... I have several spreadsheet with tons of date listed. I need to group the dates by month so i can subtotal each month. I got the subtotalling part its the group by month that i need to do without going in and entering a break between each month. 01/01/2008 Group as Jan 01/31/2008 Group as Jan 02/01/2008 Group as Feb 04/01/2008 Group as Apr 05/02/2008 Group as May 09/01/2008 Group as Sep |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grouping dates in PT; need last 6 month data | Excel Worksheet Functions | |||
| Grouping by month in a Pivot Table | Excel Discussion (Misc queries) | |||
| Grouping totals together by month per customer | Excel Discussion (Misc queries) | |||
| Grouping Date By Month | Excel Discussion (Misc queries) | |||
| grouping dates by week/month/etc. on cat. axis | Charts and Charting in Excel | |||
Hybrid Mode
