1

How can I transform a column with text like "20130213" to DATE?

Basically, I need to calculate the difference in days between 2 dates that come in the text format

Thanks a lot

ojblass
  • 21,146
  • 22
  • 83
  • 132
Tero
  • 139
  • 1
  • 11

1 Answers1

4

You can use for example 

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
sdrzymala
  • 387
  • 1
  • 10