Need only date from text

[Closed]
Report
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
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 reply

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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