The attached sheet is originally exported as a CSV file for processing. Before saving it as a XLSX, I need to format the Exp date column so that it shows the month (mmm) followed by the year (yy). The trouble is that sometimes a specific day will exist and sometimes it will not. When it does show a day, then it should be represented as mmm dd, yy and when a day is not available (which is most of the time), it should just be represented as mmm yy. I am trying to do this within a single formula itself and not as part of a macro. Assistance is greatly appreciated.