Converting Text Date to Date/Value

  • Thread starter Thread starter Alex Barrow
  • Start date Start date
A

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
 
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!
Click to expand...

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


Mit freundlichen Grüssen
Claus Busch
 
Thanks very much, this seems to work !

Regards

Claus Busch said:
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
Click to expand...
 
Back
Top