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