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)

Argument	Type	Description
date	Date	The date to format
pattern	String	The pattern by which to format the date

=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

Updated 5 months ago

Did this page help you?