March 10, 2016
July 16, 2010
Thanks for sharing your sample data.
If you add a Filter to column A and then click the Filter drop down you can see that some of the dates are not grouped. This is because these dates are in a text format.This data starts on row 87 through 545 (note, it may not be consecutive, I didn't check).
You must fix this format for Excel to be able to group the dates in both a Filter or a PivotTable. The simplest solution is to:
1. Type a 1 in any empty cell.
2. Copy that cell.
3. Select all of the dates in column A, even the ones that are in the correct format, if it's easier.
4. Paste Special > select radio buttons: Value and Multiply > OK
Your data should now be in the correct time and date format so you can refresh your PivotTable and complete the grouping of the dates.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Dharan Prakash Mishra
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas