Offsets and DST
TZ_ABBR
Returns the short time zone abbreviation for an instant.
Syntax
=TZ_ABBR(zone, [datetime])Parameters
NameTypeDescription
Name
zoneTypetext
DescriptionIANA time zone.
Name
datetime?Typetext, number, or date
DescriptionInstant to evaluate. Defaults to now.
Returns
A short abbreviation such as "PST" or "PDT".
Example
=TZ_ABBR("America/Los_Angeles", "2026-01-15")Result: PST