Timezone Toolkit

Parse, Format, and Epochs

TZ_TO_ISO

Renders a date/time as an ISO 8601 string with offset.

Syntax

=TZ_TO_ISO(datetime, zone)

Parameters

Namedatetime
Typetext, number, date, or range
DescriptionThe date/time interpreted in zone.
Namezone
Typetext
DescriptionIANA time zone.

Returns

An ISO 8601 string with offset.

Example

=TZ_TO_ISO("2026-06-01 09:00", "America/New_York")

Result: 2026-06-01T09:00:00-04:00

    xs