Convert Date to MMYY format

  • Thread starter Thread starter Doug Muegge
  • Start date Start date
D

Doug Muegge

I would like to change the underlying date format from e.g. 01-May-09 to
May-09. I can change the format so that the displayed date is in correct
format but the underlying date is still in DD/MM/YYYY format. The purpose is
to do pivot charts to show how many defects per month over the last five
years.
 
Rather than reformat the cell to Custom > mmm-yy

use something like:

=TEXT(A1,"mmm-yy")
 
Back
Top