Conversion from text to date

Closed

JM - 8 Dec 2009 à 02:09
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 8 Dec 2009 à 06:06

Hello,

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

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

Regards,

JM

1 response

Réponse 1 / 1

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
8 Dec 2009 à 06:06

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.