In Libreoffice Calc, how to format strings containing dates

Suppose I set a cell to say:

       ="today is "&today() 

This displays as:

      today is 44404

44404 being the number of days since Jan 1 1900 (I think)

What I’m actually after is something like:

      today is 27 July 2021

Is this even possible? I’m starting to thing it can’t be done.

="today is "&Text(today();“D MMMM YYYY”)



image description

(I can’t +1 due to my status)