Calc: How do I use text and TODAY() function in same cell with date properly formated?

="Date: "&TODAY()

Results in image description

…which I’m assuming is numeric code for today, but I would like to format it as MM/DD/YY as if I were using the TODAY() function without text, which returns today’s date in the proper format…

image description image description

  1. Use simple formula

    ="Date is: " & TEXT(TODAY();“MM/DD/YY”)

image description


  1. Use user-defined format of cell

Awesome! Thank you.