Components and Math
TZ_PART
Extracts a single date/time component as seen in a zone.
Syntax
=TZ_PART(datetime, zone, part)Parameters
NameTypeDescription
Name
datetimeTypetext, number, date, or range
DescriptionThe date/time interpreted in zone.
Name
zoneTypetext
DescriptionIANA time zone.
Name
partTypetext
DescriptionComponent name such as year, month, day, hour, weekdayname, offset, abbr, isdst, or unix.
Returns
The requested component value.
Example
=TZ_PART("2026-06-01 09:00", "Asia/Tokyo", "weekdayname")Result: Monday