Conversion from text to date

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

How I can convert this text date to date...

14/02/2011 = 14-Feb-2009 (This should be the result)

Regards,

JM

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
suppose a1 has the entry
14/02/2011

in B1 copy this formula

=LEFT(A1,2)&"-"&TEXT(MID(A1,4,2)*29,"mmmm")&"-"&RIGHT(A1,4)


you will get

14-February-2011

I still am t rying to find out what that number 29 is doing here. any how this works.