Forum Discussion
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 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 ?
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).
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.
- Worked perfectly, my friend. So good of you. Thanks a lot.
Hi, to all!
You can use too:
=DATEVALUE(LEFT(A1,10))
Blessings!
