Convert
TZ_TODAY
Returns today's date in a selected time zone.
Syntax
=TZ_TODAY([zone], [format])Parameters
NameTypeDescription
Name
zone?Typetext
DescriptionIANA time zone. Defaults to the spreadsheet/script time zone.
Name
format?Typetext
DescriptionOptional output format. Defaults to "yyyy-MM-dd".
Returns
The current date in the selected zone.
Example
=TZ_TODAY("Pacific/Auckland")Result: 2026-06-09
The exact result depends on the current instant.