Reference
No results for 'undefined'
    Powered by Algolia

    FORMAT_DATE

    Converts date/time in the first argument to the text with the format specified in second argument

    Syntax

    =FORMAT_DATE(date, format_string)

    Parameters

    1. date
      • Type: DateTime
      • Description: The date to format, in Excel-style.
    2. format_string
      • Type: String
      • Description: The string with date format.

    Returns

    • Type: String
    • Description: Returns formatted date time text string

    Example

    =FORMAT_DATE(NOW(), "YYYY-MM-DD")

    For the specifics of the 2nd argument in this function, see here.

    See Also

    Contents