Forum Discussion
Heavy_Duty
Mar 14, 2020Copper Contributor
combine text with =today function
I want to combine the text string 'LAST OPENED ' with the =TODAY() function in a single cell. What is the proper syntax? I have tried the following in cell B1 which is formatted as General: 'LAST OP...
Riny_van_Eekelen
Mar 14, 2020Platinum Contributor
Heavy_Duty I believe you also need to specify the date format like this:
="LAST OPENED "&TEXT(TODAY(),"dd-mm-yyyy")
Without the format, the formula returns this:
- TarasH1Mar 01, 2024Copper Contributor
- HansVogelaarMar 01, 2024MVP
; is not more or less correct than , in itself.
It is the list separator specified in your system settings.
Usually, if you use point as decimal separator, then comma is the list separator.
And if comma is your decimal separator, then semicolon is the list separator.
- s31064Feb 02, 2024Copper ContributorNo, the slashes work as well.