Pivot table & dates

  • Thread starter tawtrey(remove this )
  • Start date
T

tawtrey(remove this )

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!
 
T

tawtrey(remove this )

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!
 
T

tawtrey(remove this )

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.
 
Top