Convert
TZ_TO_UTC
Converts a zoned date/time into UTC.
Syntax
=TZ_TO_UTC(datetime, fromZone, [format])Parameters
NameTypeDescription
Name
datetimeTypetext, number, date, or range
DescriptionThe local date/time interpreted in fromZone.
Name
fromZoneTypetext
DescriptionThe source IANA time zone.
Name
format?Typetext
DescriptionOptional output preset or format pattern.
Returns
The UTC date/time.
Example
=TZ_TO_UTC("2026-06-01 09:00", "America/New_York")Result: 2026-06-01 13:00:00
Notes
IANA zones such as America/New_York are preferred. UTC offsets such as UTC+5:30 are accepted where the function expects a zone.
Date cells, text values, and ranges are supported by the conversion and formatting functions.
Use the optional format argument with presets such as iso, date, time, full, serial, and unix, or with Luxon format tokens.