Components and Math
TZ_ADD
Adds or subtracts a duration in a zone.
Syntax
=TZ_ADD(datetime, zone, amount, unit, [format])Parameters
NameTypeDescription
Name
datetimeTypetext, number, date, or range
DescriptionThe date/time interpreted in zone.
Name
zoneTypetext
DescriptionIANA time zone.
Name
amountTypenumber
DescriptionAmount to add. Use a negative number to subtract.
Name
unitTypetext
Descriptionyears, months, weeks, days, hours, minutes, or seconds.
Name
format?Typetext
DescriptionOptional output preset or format pattern.
Returns
The resulting local date/time.
Example
=TZ_ADD("2026-03-08 01:30", "America/New_York", 2, "hours")Result: 2026-03-08 04:30:00