hi
you could add a column and use this fomula
=month(a1)
then exclude the date columun from your pivot table while including the
month column.

Regards
FSt1



"yhoy" wrote:

I have two columns of data in format of mm/dd/yyyy. How do I convert so it
shows only "mmm"? And, is there an easy way to set up range as "1/1/2008" -
"1/31/2008" in pivot table?

Thanks...