I have a column that contains a list of paid invoices and the payment date is
showing as dd/mm/yy. I need to do a pivot by month. How do I change my cell
from the current format so the month is shown in one cell and the year in the
next cell?

This extracts the year from a date
=YEAR(DateValue)

This extracts the month from a date

=MONTH(DateValue)

And just in case, this extract the day

=DAY(DateValue)
--
Kevin Backmann


"Eva" wrote:

I have a column that contains a list of paid invoices and the payment date is
showing as dd/mm/yy. I need to do a pivot by month. How do I change my cell
from the current format so the month is shown in one cell and the year in the
next cell?

Start by building your Pivot Table using the DATE field.

Then, assuming the DATE is a ROW field in the Pivot Table
Right-Click on the DATE field....Select: Group and Show Detail.....Group
Click on Months....Click on Years....Click [OK]

That will display those 2 fields, instead of the dates.

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"Eva" wrote in message
...
I have a column that contains a list of paid invoices and the payment date
is
showing as dd/mm/yy. I need to do a pivot by month. How do I change my
cell
from the current format so the month is shown in one cell and the year in
the
next cell?