You are reading a single comment by @Drakien and its replies. Click here to read the full conversation.
  • Or you can use MID instead:

    =DATE(B1,MID(A1,3,2),LEFT(A1,2))
    
About

Avatar for Drakien @Drakien started