| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert date field to month in Pivot table
I have a Table wich has date fileds,
Date Order No. Qty Shipped 01-27-07 03-19-07 03-20-07 How do I go about to create a pivot table that groups this by month on the Page Filed of the pivot table. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summin Pivot Table data from a date selected in the Page field | Excel Discussion (Misc queries) | |||
| how to change date formating-grouped by month in pivot table | Excel Discussion (Misc queries) | |||
| Calculated Pivot table field on YTD £(subract Mar-feb)=month | Excel Worksheet Functions | |||
| pivot table date field | Excel Worksheet Functions | |||
| Pivot table will not group a date field | Excel Discussion (Misc queries) | |||
Threaded Mode
