Mar 13 2020 05:22 PM
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.
Mar 13 2020 06:11 PM - edited Mar 14 2020 07:50 AM
Mar 13 2020 06:18 PM - edited Mar 14 2020 07:52 AM
Mar 13 2020 11:17 PM
@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:
Mar 14 2020 09:57 AM
Feb 13 2021 02:07 PM
@Heavy_Duty this not working in Excel365
Feb 02 2024 10:47 AM
Mar 01 2024 09:47 AM
Mar 01 2024 11:32 AM
; 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.