Change date in Excel
Hello Experts.
I have a huge spreadsheet and I need to create a pivot table counting the rows in the table grouped by date. Problem is, the raw data has the date including the time stamp. How can I change the date so the pivot table only takes into account the date and not the time?
Thanks
I have a huge spreadsheet and I need to create a pivot table counting the rows in the table grouped by date. Problem is, the raw data has the date including the time stamp. How can I change the date so the pivot table only takes into account the date and not the time?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
by the way...
you can use GROUP in the pivot table...
this will allow you to maintain the data as is and group by Year, Quarter, Month, Day etc etc
If you pivot table your data and put the date as the row...
Right click the data and select group then group by days/months etc etc.
The attached file should provide an example of this in action.
ATB
Steve.
Group-Example.xlsx
you can use GROUP in the pivot table...
this will allow you to maintain the data as is and group by Year, Quarter, Month, Day etc etc
If you pivot table your data and put the date as the row...
Right click the data and select group then group by days/months etc etc.
The attached file should provide an example of this in action.
ATB
Steve.
Group-Example.xlsx
ASKER