transform text into date format

[mireille]

Hello

I have a problem with date.

The file has in column A to C the following text :
CODE COMMITTEE / COMITE CODE
TUESDAY 10 FEBRUARY 2009, 9:30 am / MARDI 10 FEVRIER 2009, 9h30

I can substract the date in english with the function :
Date1 = Left(Trim(Right(A2, Len(A2) - Find("/", A2, 25))), Find(",",
Trim(Right(A2, Len(A2) - Find("/", A2, 25)))) - 1)
The result is "10 FEBRUARY 2009".

Now, I need to transform this text in date format.

Thanks for your help!
Mireille

 

[KARL DEWEY]

CVDate( Left(Trim(Right(A2, Len(A2) - Find("/", A2, 25))), Find(",",
Trim(Right(A2, Len(A2) - Find("/", A2, 25)))) - 1) )