Convert
TZ_CONVERT
Converts a date or time from one time zone to another.
Syntax
=TZ_CONVERT(datetime, fromZone, toZone, [format])Parameters
NameTypeDescription
Name
datetimeTypetext, number, date, or range
DescriptionThe source date/time. Text with an offset, such as Z or +02:00, is treated as an absolute instant.
Name
fromZoneTypetext
DescriptionSource zone, such as "America/New_York" or "UTC".
Name
toZoneTypetext
DescriptionTarget zone, such as "Asia/Tokyo".
Name
format?Typetext
DescriptionOutput preset or Luxon pattern. Defaults to "yyyy-MM-dd HH:mm:ss".
Returns
The converted date/time. Range input spills converted results.
Example
=TZ_CONVERT("2026-06-01 09:00", "America/New_York", "Asia/Tokyo")Result: 2026-06-01 22: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.