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
Updated 8 months ago