Date Codes

  • Thread starter Thread starter cpark1
  • Start date Start date
C

cpark1

I am trying to use the Pivot table tools to build charts.

My date format is 01-Jan-06 and I need to parse the entries as month
and year otherwise when I select the date column as an axis for my
charts all of the dates are shown. Is there a formula to convert the
date column into two new columns one for Month and one for Year to
save me from having to manually create the columns?

Thanks,
 
Right click a date in the pivot table and select group and show detail, then
select group and months and years. That will create 2 columns, one with
years and one with months
 
Back
Top