Add a column for the month =MONTH(A1) and copy down, and include that in the
pivot. Maybe add a year and day column as well.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"flow23" wrote in message
...
I have a column with dates in dd/mm/yyyy . I want to get rid of the dd.
although converting the date format does the job.. but the dd/mm/yyyy
value
still remains on the formula bar. this then makes pivot table analysis
difficult as I want to analyse by month.

help please