Timezone Toolkit

Parse, Format, and Epochs

TZ_FORMAT

Formats a date/time in a zone using presets or Luxon tokens.

Syntax

=TZ_FORMAT(datetime, zone, format, [locale])

Parameters

Namedatetime
Typetext, number, date, or range
DescriptionThe date/time interpreted in zone.
Namezone
Typetext
DescriptionIANA time zone.
Nameformat
Typetext
DescriptionPreset such as "iso" or a Luxon token pattern.
Namelocale?
Typetext
DescriptionLocale code such as "es". Defaults to "en".

Returns

Formatted text. Range input spills formatted values.

Example

=TZ_FORMAT("2026-06-01 09:00", "Europe/Madrid", "cccc d LLLL", "es")

Result: lunes 1 junio

    xs