MM/DD/YY to "month Year"

[Lomax]

One thing that would make my life a little easier. I have a dates that the
occurrence would be due, they are shown as:

03/22/03
02/14/03
03/07/02
05/31/02
07/06/02
02/13/03
02/13/03
03/15/03
04/13/02
11/29/02

What I would like is:
March 03
February 02
March 02
etc.

I made a pivot table, after a lot of help from Ken, and have the date due at
the top. I can select the month and it will only show that data. I have to
go in manually and type"`March 03" (notice the ` ) and copy paste for dates
that are coming due in March. Is there an easier way to do this? I used
the format cells/date and it has the day of the month hidden, when I use the
drop down on the Table I have a lot of Mar/03 to select from. I only want
to have a choice of which month I see not all of the individual dates.

There is a lot of good info in this group.

Thanks lomax

[steve smallman]

format/cells/Custom "mmmm yy" 4ms 2ys

Steve

>.
>

[Dave Peterson]

One more option if you want all the dates to have the same date in that month:

=date(year(a1),month(a1),1)

formatted as: mmmm dd

But did you know that you can group stuff inside your pivot table. I'd look
there first and do month and year.

Right click on the grey button-like cell that has your date heading. Select
"group and show detail", then group. Click on both Month and Year.

Might be enough.

--

Dave Peterson
ec3...@msn.com