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.