Offsets and DST
TZ_OFFSET
Returns a DST-aware UTC offset string for a time zone.
Syntax
=TZ_OFFSET(zone, [datetime])Parameters
NameTypeDescription
Name
zoneTypetext
DescriptionIANA time zone to evaluate.
Name
datetime?Typetext, number, or date
DescriptionInstant to evaluate. Defaults to now.
Returns
A UTC offset such as "-07:00" or "+05:30".
Example
=TZ_OFFSET("America/Denver", "2026-07-01")Result: -06:00