Convert
TZ_FROM_UTC
Converts a UTC date/time into a target time zone.
Syntax
=TZ_FROM_UTC(datetime, toZone, [format])Parameters
NameTypeDescription
Name
datetimeTypetext, number, date, or range
DescriptionThe UTC date/time to convert.
Name
toZoneTypetext
DescriptionThe target IANA time zone.
Name
format?Typetext
DescriptionOptional output preset or format pattern.
Returns
The local date/time in the target zone.
Example
=TZ_FROM_UTC("2026-06-01 13:00", "America/New_York")Result: 2026-06-01 09: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.