with the date in A1 the following formula should work:

then use

Single formula:

Date-example.xlsx

Date-example.xlsx

**=DATEVALUE(MID(A1,FIND("-"**,A1)+1,2) & " " & LEFT(A1,FIND("-",A1)-1) & " " & RIGHT(A1,4)) then use

**=TEXT(B1,"mmddyy")**to get to the desired format :)Single formula:

**=TEXT(DATEVALUE(MID(A1,FIN**D("-",A1)+1,2) & " " & LEFT(A1,FIND("-",A1)-1)& " " &RIGHT(A1,4)),"mmddyy") Date-example.xlsx

Date-example.xlsx