Extract Data to be Date Format (dd-mm-yyyy)

[muhammad susanto]

hi all..

how to figure out this problem:

original list	after extracted (dd-mm-yyyy)
ND-60 05 Desember 2024	05/01/2024
ND-65 19 Desember 2024	19/12/2024
ND-564 19 Desember 2024	etc…
ND-08 06 Februari 2024
ND-13 05 Maret 2024
ND-22 01 April 2024
ND-176 01 April 2024
ND-29 06 Mei 2024
ND-35 06 Juni 2024
ND-44 04 Juli 2024
ND-348 04 Juli 2024
ND-52 06 Agustus 2024
ND-63 04 September 2024
ND-69 04 Okt 2024
ND-535 04 Okt 2024

i hope someone would help me out this situation
date format in dd-mm-yyyy

sst.

 

[HighAndWilder]

hi all..

how to figure out this problem:

original list	after extracted (dd-mm-yyyy)
ND-60 05 Desember 2024	05/01/2024
ND-65 19 Desember 2024	19/12/2024
ND-564 19 Desember 2024	etc…
ND-08 06 Februari 2024
ND-13 05 Maret 2024
ND-22 01 April 2024
ND-176 01 April 2024
ND-29 06 Mei 2024
ND-35 06 Juni 2024
ND-44 04 Juli 2024
ND-348 04 Juli 2024
ND-52 06 Agustus 2024
ND-63 04 September 2024
ND-69 04 Okt 2024
ND-535 04 Okt 2024

i hope someone would help me out this situation
date format in dd-mm-yyyy

sst.

Try this where A2 is the first cell in the Original List column and copy it down.

=DATEVALUE(TEXTAFTER(A2," "))

 

[muhammad susanto]

hi man...

not work show #name?

 

[Cubist]

Are you using version 365?

 

[muhammad susanto]

not, i'm using 2021 pro plus

 

[Cubist]

Try this:

=--RIGHT(A2,LEN(A2)-FIND(" ",A2))

 

[muhammad susanto]

not fully work...for date

ND-60 05 Desember 2024

ND-65 19 Desember 2024

ND-564 19 Desember 2024

the result are #value!
the date format in dd/mm/yyyy

 

[Cubist]

not fully work...for date

Which dates did it work for?
Which language is your local setting?

 

[muhammad susanto]

indonesia language,

for formula like eg. this format =--RIGHT(F2;LEN(F2)-FIND(" ";F2))
note:
this work for me (the result is correct)

ND-22 01 April 2024

ND-63 04 September 2024

 

[Cubist]

If you type "05 Desember 2024" into a blank cell. Does it accept as date?