Converts a value to text. 

TEXT(date, format)
Formats a date according to Excel's syntax. Allowed format characters are:

yy two digit year
yyyy four digit year
m month as one or two digits
mm month as two digits
mmm for the short name of the month ("Jan")
mmmm  for the long name of the month ("January")
d day of the month as one or two digits
dd  day of the month as two digits
ddd day of the week, short form ("Wed")
dddd  day of the week, long form ("Wednesday")
hh  for hours.
mm* for minutes
AM/PM  for the string "AM" or "PM"
A/P  for "A" or "P" 

The meaning of m  is contextual: if it comes after an h  or immediately before an s , it means "minutes." 

If one of AM/PM  or A/P  is specified, hours are displayed in the 12-hour format; otherwise they are displayed in the 24-hour format.

Any characters that are not listed above are reproduced verbatim in the output string, most commonly - , / , or : .


TEXT(DATETIME("2019-11-01"), "dd/mm/yyyy")  returns 01/11/2019
TEXT(DATETIME("2019-11-01 1:34 PM"), "HH:MM") returns 13:34

Did this answer your question?