Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Greetings,
I've created a pivot table that has dates along the top and quantities sumed in the data field. The problem is that Excel is not combining the date like I want. I want the date columns at the top to be distince my month-year, but excel is distinct for full date. To give an example. I have columns for January 2004 such as this: 01/01/04 01/02/04 01/03/04 I want a single column for January 2004 with quantities added together and not seperated by the day. Please help. Thank you. Rod Neville |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
How to change drop down values based on another cell value? | Excel Discussion (Misc queries) | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
search for latest date | Excel Worksheet Functions | |||
Create new series (on the same chart) for every change of values in a combobox | Charts and Charting in Excel |