EXTRACT DATE FROM A TEXT

[Rui Pires]

Hi all;


Thanks all

 

[Mike H..]

Hi all;

View attachment 10625
Thanks all

Hi,

If what you've posted is representative of you data then this should work. Format with a date format of your choosing.


=--TRIM(MID(SUBSTITUTE("," & A1&REPT(" ",6),",",REPT(" ",255)),2*255,255))

 

[Rui Pires]

Really works !!
Thanks a lot

 

[Rui Pires]

Hi,

If what you've posted is representative of you data then this should work. Format with a date format of your choosing.


=--TRIM(MID(SUBSTITUTE("," & A1&REPT(" ",6),",",REPT(" ",255)),2*255,255))

Really works

Hi,

If what you've posted is representative of you data then this should work. Format with a date format of your choosing.


=--TRIM(MID(SUBSTITUTE("," & A1&REPT(" ",6),",",REPT(" ",255)),2*255,255))

Really works !!
Thanks a lot

 

[Khalid NGO]

Hi Rui,
Your problem is solved, however, you can try this too:
=DATEVALUE(MID(A1,10,1)&"/"&MID(A1,12,1)&"/"&MID(A1,14,4))

 

[Rui Pires]

Hi Khalid ,

your formula does not work, sorry !

Thanks

 

[Rui Pires]

u can see it in attached print

 

[Khalid NGO]

Oops...
Thanks Rui for feedback.
Above formula worked on A1 it tried it, but didn't on A2...

Well you can try this also:
=DATEVALUE(SUBSTITUTE(SUBSTITUTE(A1,"this day,",""),",is unique",""))