Components and Math
TZ_RELATIVE
Creates a human-friendly relative time phrase.
Syntax
=TZ_RELATIVE(datetime, zone, [baseDatetime], [baseZone])Parameters
NameTypeDescription
Name
datetimeTypetext, number, date, or range
DescriptionThe date/time to describe.
Name
zoneTypetext
DescriptionIANA zone for datetime.
Name
baseDatetime?Typetext, number, or date
DescriptionReference instant. Defaults to now.
Name
baseZone?Typetext
DescriptionZone for baseDatetime. Defaults to zone.
Returns
A phrase such as "in 3 hours" or "2 days ago".
Example
=TZ_RELATIVE("2026-06-01 12:00", "UTC", "2026-06-01 09:00", "UTC")Result: in 3 hours