Convert Timestamp to Date in Google Sheets

Robert Thorne
Robert Thorne
• • 1 min read

How Can I Convert 2020-12-14T18:24:27.000Z to 12/14/2020 in Google Sheets? the Format > Number > Date Command Does Not Change the Timestamp to a Date. the...

Convert Timestamp to Date in Google Sheets

How can I convert 2020-12-14T18:24:27.000Z to 12/14/2020 in Google Sheets?

The Format > Number > Date command does not change the timestamp to a date.

The conversion can occcur in-place or a separate column.

1 Answer

You can extract the date portion of the timestamp using MID() then use DATEVALUE() to convert it to date format.

=DATEVALUE(MID(A1,1,10))

Then use Format > Number > Date command.

References:

MID()

DATEVALUE()

Must Read

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Robert Thorne

Robert Thorne

Automotive & Future Transportation Editor
Twitter Linkedin

Robert Thorne covers electric vehicle innovations, autonomous driving systems, global mobility trends, and automotive engineering developments.

Share this article
Twitter Facebook Pinterest