Zones, Lookup, and Scheduling
TZ_VALIDATE
Checks whether a zone string is recognized.
Syntax
=TZ_VALIDATE(zone)Parameters
NameTypeDescription
Name
zoneTypetext
DescriptionZone string to test.
Returns
TRUE for valid IANA zones and supported offsets, otherwise FALSE.
Example
=TZ_VALIDATE("America/New_York")Result: TRUE