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

Dates In Excel 5
Send meeting request for different dates (no repetition) to different people 0
Pivot table Days to Months 0
How do I add amounts referencing specific dates? 7
Check if a date comes before/after a range of dates 0
Reverse Index Match 2
Dealing with a Pivot Table (when I don't want to) 0
How to use/create code in MS Word to calculate age? 0

Top