Pivot table & dates

G

Guest

I have a table of information that currently has entries by mm/dd/yy that I
want to read in a pivot table just as mm/yy. I run into a problem when I try
to convert the date because it is read by its number (i.e., 38314 instead of
as 11/23/04) and so if I use a LEFT function, it doesn't work.

Does anyone have any ideas?

Thanks!
 
G

Guest

I'm not certain how to group by month for a pivot table but did get it to
work by using "TEXT(D3,"MM YYYY").

However, now when I use that in my pivot table, it lists the dates across
the top (columns) as "01 2003" then "01 2004" then "02 2003" and so on. When
I would really like it to be: "01 2003" then "02 2003" and so on. Can I do
this or just be thankful for what I've got?

Thanks!
 
G

Guest

Figured it out.

I created a custom sort list from Tool>Options where I defined the order I
wanted the columns in. and then sorted based on that custom sort list.
 

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

date 2
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy 1
Pivot Table date format 1
Determine accuracy percentage between two dates 2
VLOOKUP Dates in a Pivot Table 1
Pivot Table Date Format 2
Count Between dates 11
Date prob with Pivot Table 1

Top