Parse, Format, and Epochs
TZ_TO_UNIX
Converts a zoned date/time to a Unix timestamp.
Syntax
=TZ_TO_UNIX(datetime, zone, [unit])Parameters
NameTypeDescription
Name
datetimeTypetext, number, date, or range
DescriptionThe date/time interpreted in zone.
Name
zoneTypetext
DescriptionIANA time zone.
Name
unit?Typetext
DescriptionUse "s" for seconds or "ms" for milliseconds.
Returns
A Unix timestamp.
Example
=TZ_TO_UNIX("2026-06-01 09:00", "UTC")Result: 1780304400