These docs are for v1.0. Click to read the latest docs for v1.2.

FORMAT_DATE

Returns a string representing the date, formatted according to the given pattern. Pattern formatting is generally the same as supported by Excel.

Syntax

=FORMAT_DATE(date, pattern)

Arguments

ArgumentTypeDescription
dateDateThe date to format
patternStringThe pattern by which to format the date

Examples

=FORMAT_DATE(DATE(2019, 12, 25),"MM-dd")25

=FORMAT_DATE(DATE(2020, 2, 3, 4, 5),"YYYY-MM-dd, hh:mm")2020-02-03, 04:05