Previous Topic Next Topic

Need only date from text

Closed
Anu - Sep 30, 2016 at 07:11 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 30, 2016 at 07:50 AM
Hello,

how to get only date when a cell contains text.

EX: MON 12/20/1968 12:30 .

I want only the date 12/20/1968

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 30, 2016 at 07:50 AM
Anu, Good morning.

Try to use:

A1 --> MON 12/20/1968 12:30

B1 --> =DATEVALUE(MID(A1, 5, 10))
Format A1 as DATE

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0