Conversion from text to date

[Closed]
Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!