| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table dates not times
I have a worksheet with date and time all in one cell
i.e. 12/05/2006 15:32:36 I want to pivot table all similar dates together i.e. all occurrences of 12/05/2006 regardless of the time How do I do this please? ta -- Vass |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot table dates not times
The quickest way would be to create another field at the end of your date,
call it date and then set the cells =Date({cell with date in it}). HTH. "Vass" wrote: I have a worksheet with date and time all in one cell i.e. 12/05/2006 15:32:36 I want to pivot table all similar dates together i.e. all occurrences of 12/05/2006 regardless of the time How do I do this please? ta -- Vass |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot table dates not times
"DaveO" wrote in message ... The quickest way would be to create another field at the end of your date, call it date and then set the cells =Date({cell with date in it}). Nope, Excel is asking for year, month, day with that function -- Vass |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot table dates not times
S'ok sorted it
=DAY(A16) & "/" & MONTH(A16) & "/" & YEAR(A16) -- Vass |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot table dates not times
In the pivot table, right-click on the date field, and choose Group and
Show DetailGroup From the list, select Days, click OK Vass wrote: I have a worksheet with date and time all in one cell i.e. 12/05/2006 15:32:36 I want to pivot table all similar dates together i.e. all occurrences of 12/05/2006 regardless of the time How do I do this please? ta -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates Formats in Pivot Table Help | Excel Worksheet Functions | |||
| Pivot table - group dates per week or month | Excel Discussion (Misc queries) | |||
| Sort a Column of Dates in Pivot Table | Excel Worksheet Functions | |||
| Pivot table keeps dupping to another linked pivot table | Excel Discussion (Misc queries) | |||
| Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Hybrid Mode
