In Libreoffice Calc, how to format strings containing dates

[GeneralAgg]

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.

[PKG]

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

---

or

Strg+1

[GeneralAgg]

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