Reformat dates

  • Thread starter Thread starter GARY
  • Start date Start date
G

GARY

Dates are displayed as follows:
31-Aug
9-Sep
15-Sep
31-Oct
1-Nov

How can I get the dates to be displayed as follows:

Aug 31
Sep 9
Sep 15
Oct 31
Nov 1
 
If the dates are real Excel dates, you can format as mmm d

If they are not Excel dates but text, you can either change them to dates
first, or just shuffle the text by =RIGHT(A2,3)&" "&LEFT(A2,LEN(A2)-4)
 
Back
Top