Forum Discussion
Solved
Help required in Date function
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 ...
Hi, to all!
You can use too:
=DATEVALUE(LEFT(A1,10))
Blessings!
Sorry, I did not use right (A1,10); I used left (A1,10).