How do I convert dates to months in Pivot Tables?

E

elaihaw

I am working in a Pivot Table one column is dates (01/23/09, 04/04/09 etc.)
I want to group the dates by months but, when I have (Date) in the field
column it does not give me the option to group the field it is grayed out.
What am I doing wrong?
 
D

Dave Peterson

Is (Date) the 6 character string ( D a t e ) ?
Or is it a placeholder for a real date?

You can only group fields where all the data is numeric (that includes dates).
So if you thought all your entries in that field were really dates, you missed
one. (Even empty cells won't qualifiy as numeric.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I add amounts referencing specific dates? 7
Pivot table field. 2
Grouping dates in pivot table 3
counting months 4
dates inbetween 3
Grouping Dates in Excel 2007 Pivot Tables 1
Aging Report 4
sorting dates in a pivot table 1

Top