Offsets and DST
TZ_NAME
Returns the long localized time zone name for an instant.
Syntax
=TZ_NAME(zone, [datetime], [locale])Parameters
NameTypeDescription
Name
zoneTypetext
DescriptionIANA time zone.
Name
datetime?Typetext, number, or date
DescriptionInstant to evaluate. Defaults to now.
Name
locale?Typetext
DescriptionLocale code such as "fr". Defaults to "en".
Returns
A long name such as "Pacific Daylight Time".
Example
=TZ_NAME("America/Los_Angeles", "2026-07-01")Result: Pacific Daylight Time