ExcelBanter - ="my text" &TODAY()

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ="my text" &TODAY() (https://www.excelbanter.com/excel-worksheet-functions/148936-%3D-my-text-today.html)

Jock

="my text" &TODAY()

The above will return a date value (regardless of how I format the cell it's
in) rather than the date. Clever as this is, it's of no use to me whatsoever.
What I want is:
Logged today - 03/Jul but what I get is Logged today - 39267

Answers on a postcard please...

--
tia

Jock

Mike H

="my text" &TODAY()

Try:-

="Mytext " & TEXT(TODAY(),"dd:mm:yyyy")

Mike

"Jock" wrote:

The above will return a date value (regardless of how I format the cell it's
in) rather than the date. Clever as this is, it's of no use to me whatsoever.
What I want is:
Logged today - 03/Jul but what I get is Logged today - 39267

Answers on a postcard please...

--
tia

Jock

Jock

="my text" &TODAY()

Thanks Mike. You saved the day yet again. Brill.
Jock

"Mike H" wrote:

Try:-

="Mytext " & TEXT(TODAY(),"dd:mm:yyyy")

Mike

"Jock" wrote:

The above will return a date value (regardless of how I format the cell it's
in) rather than the date. Clever as this is, it's of no use to me whatsoever.
What I want is:
Logged today - 03/Jul but what I get is Logged today - 39267

Answers on a postcard please...

--
tia

Jock

All times are GMT +1. The time now is 02:16 AM.