Pivot tables and dates

[Guest]

I am creating a pivot table for a department in the healthcare clinic that I
work for. They want to run a report that shows by year of the number of
people that have gotten labs done in another facility. The Start Date column
is formatted as mm/dd/yy. Is there away that I can group the dates together
by year? All I am able to do is show each individual date. Thanks for your
help. Sue

 

[Debra Dalgleish]

Right-click on the Date field button in the pivot table
Choose Group and Show Detail>Group
Select Years, click OK

 

[Guest]

When I follow your steps, Excel says that I "Can not group that selection".
Any ideas???

 

[Debra Dalgleish]

If there are any blank cells in the date column, you won't be able to
group the dates in the pivot table.

http://www.contextures.com/xlPivot07.html

Or, if the dates are being treated as text, you won't be able to group
them. If so, you can change the dates back to numbers, as described here:

http://www.contextures.com/xlDataEntry03.html