Help required in Date function

[Sarma Vishnubhtla]

Technos - A website displays date as 2018-01-12 17:00 UTC for 12th Jan 2018. I want the conversion as 12th Jan 2018. So I copy the date from the website, and use right (A1,10). I got 2018-01-12. How do I then make it as 12th Jan 2018? So I go to format and designate the cell as date with the format 14-Mar-12. But the conversion doesn't happen. I want that the date be converted to a number in the next cell. So I give formula =A3 and designate this new cell as number with 0 decimals. But it doesn't happen. What mistake am I doing ?

[#2]

Sorry, I did not use right (A1,10); I used left (A1,10).

[#3]

Sarma,

Use this formula:

=DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))

Then highlight the cells and press Ctrl+1, from the Date category choose the format that you want.

[#4]

Worked perfectly, my friend. So good of you. Thanks a lot.

[#5 · Accepted solution]

Hi, to all!

You can use too:

=DATEVALUE(LEFT(A1,10))

Blessings!