combine text with =today function

[Heavy_Duty]

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.

[#2]

="LAST OPENED"&" :"&" "&TEXT(TODAY(),"dd/mm/yyyy")

Click Enter... That will return
LAST OPENED: 25/03/2020

(For example)

[#3]

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...

[#4]

@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:

[#5]

@Heavy_Duty 

Or just apply custom number format to the cell

[#6]

@Heavy_Duty  this not working in Excel365

[#7]

No need for the second &, simply include the : in the quoted text in the beginning, like this:
="LAST OPENED: "&TEXT(TODAY(),"dd/mm/yyyy")

[#8]

No, the slashes work as well.

[#9]

@Riny_van_Eekelen 

If to be correct:

="LAST OPENED "&TEXT(TODAY();"dd-mm-yyyy")

[#10]

@TarasH1 

; 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.