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 OP...
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...
=CONCATENATE("LAST OPENED",":"," ",TEXT(TODAY(),"dd/mm/yyyy")
You will have LAST OPENED: 14/03/2020
Pay close attention to the double quotations...