You are reading a single comment by @Drakien and its replies. Click here to read the full conversation.
  • =DATE(B1,RIGHT(A1,2),LEFT(A1,2))
    

    This'll store the result as a date, rather than a text string, so you can then date-format it however you like.

About

Avatar for Drakien @Drakien started