TZNOW
The current moment stamped with the given zone (volatile; pinned during recalc)
Try it
When to use it
When should I use TZNOW instead of NOW()?
Use TZNOW when you need a zone-aware timestamp that carries its timezone with it. NOW() returns a plain serial number with no zone context, while TZNOW returns a true instant tied to a specific IANA zone, preventing ambiguity across regions.
Will different cells calling TZNOW get different times in the same recalc?
No. TZNOW pins the clock at recalc-start, so every cell that calls TZNOW during a single recalc pass sees the identical instant, ensuring consistency across your workbook.
What happens if I pass an invalid IANA zone to TZNOW?
TZNOW returns an error if the zone string is not a valid IANA timezone identifier. Always use canonical names like "America/New_York" or "Europe/London" rather than abbreviations like "EST".
Use cases
Convert a UTC instant to Tokyo local time
Check whether a moment falls within business hours
Used in
operations · engineering · logistics
Syntax
TZNOW(zone)