Converting Text Date to Date/Value

[Alex Barrow]

Hi All,

Im having trouble converting a Text date to a DateValue, I have tried Text
to Columns and also the =Datevalue(A1) formula with no avail.

My date is written in a cell as e.g Wednesday 14th October 2009
Obviously as its in this format i cannot perform date calculations on it. Is
there a way i can convert this? I have a whole long column worth which
needs doing so typing over every one is not really an option!

Many thanks

 

[Claus Busch]

Hi Alex,

Am Wed, 14 Oct 2009 22:40:10 +0100 schrieb Alex Barrow:

My date is written in a cell as e.g Wednesday 14th October 2009
Obviously as its in this format i cannot perform date calculations on it. Is
there a way i can convert this? I have a whole long column worth which
needs doing so typing over every one is not really an option!

try =--SUBSTITUTE(MID(A1,FIND(" ",A1)+1,99),"th",) and format as date.


Mit freundlichen Grüssen
Claus Busch

 

[Alex Barrow]

Thanks very much, this seems to work !

Regards

Hi Alex,

Am Wed, 14 Oct 2009 22:40:10 +0100 schrieb Alex Barrow:


try =--SUBSTITUTE(MID(A1,FIND(" ",A1)+1,99),"th",) and format as date.


Mit freundlichen Grüssen
Claus Busch