Forum Discussion
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 OPENED ',=TODAY()
Thanks in advance for any help I can get.
- ="LAST OPENED"&" :"&" "&TEXT(TODAY(),"dd/mm/yyyy")
Click Enter... That will return
LAST OPENED: 25/03/2020
(For example)- No need for the second &, simply include the : in the quoted text in the beginning, like this:
="LAST OPENED: "&TEXT(TODAY(),"dd/mm/yyyy")
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:
- No, the slashes work as well.
; 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.
- You can also do
=CONCATENATE("LAST OPENED",":"," ",TEXT(TODAY(),"dd/mm/yyyy")
You will have LAST OPENED: 14/03/2020
Pay close attention to the double quotations... Heavy_Duty this not working in Excel365
