I would insert a column and put in the formula =month(a1)

This will give you the month for your pivot table and you can group by
that


--
eluehmann
------------------------------------------------------------------------
eluehmann's Profile: http://www.excelforum.com/member.php...o&userid=13095
View this thread: http://www.excelforum.com/showthread...hreadid=374124