Forum Discussion

Heavy_Duty's avatar
Heavy_Duty
Copper Contributor
Mar 14, 2020

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...
excel
Formulas and Functions
Abiola1's avatar
Abiola1
MVP
Mar 14, 2020
="LAST OPENED"&" :"&" "&TEXT(TODAY(),"dd/mm/yyyy")

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

(For example)
s31064's avatar
s31064
Copper Contributor
Feb 02, 2024
No need for the second &, simply include the : in the quoted text in the beginning, like this:
="LAST OPENED: "&TEXT(TODAY(),"dd/mm/yyyy")

Resources