ISODATE

Creates a date from an ISO8601-formatted string. See ISO8601 formatting for more details.

Syntax

=ISODATE(value)

Arguments

Argument	Type	Description
value	String	ISO8601-formatted string

Examples

In the following examples, the current browser has a timezone offset of -7 hours. For more information about offsets see UTC Offset.

=ISODATE("2020-01-01T00:00:00+0000")→Dec 31, 2019 5:00 PM

=ISODATE("2016-06-01T04:15:00+0000")→`May 31, 2016 10:15 PM

=ISODATE("2020-02-03")→Feb 3, 2020 12:00 AM

=ISODATE("2020-01")→Jan 1, 2020 12:00 AM

=ISODATE("2021-W01-1")→Dec 30, 2019 12:00 AM