Convert
TZ_NOW
Returns the current date and time in a time zone.
Syntax
=TZ_NOW([zone], [format])Parameters
NameTypeDescription
Name
zone?Typetext
DescriptionIANA time zone. Defaults to the spreadsheet/script time zone.
Name
format?Typetext
DescriptionOptional output preset or format pattern.
Returns
The current date/time in the selected zone.
Example
=TZ_NOW("Europe/London", "full")Result: June 8, 2026 at 8:24 AM GMT+1
The exact result depends on when the sheet recalculates.