0

I have a very troublesome date format that I need to convert to standart short date as DD.MM.YYYY. I have tried some formulas as below but I cannot reach the true output. Any help will be appreciated...

formulas & outputs

BTurkeli
  • 91
  • 1
  • 2
  • 15

1 Answers1

1

Use this:

=DATE(MID(A1,7,4),MID(A1,4,2),LEFT(A1,2))

Then format it as DD.MM.YYYY

enter image description here

Scott Craner
  • 148,073
  • 10
  • 49
  • 81