=CONCATENATE("today_is ",TODAY())

[Steven Stadelhofer]

Hello,

I was trying to develop a formula(function) in one cell
which would say... "Today is 6/21/04" ...I tried to use
the fomula above
=CONCATENATE("today_is ",TODAY())
when today is 6/14/2004
but it resulted in "today_is 38159" e.g., it converted
todays date to the serial number 38159. Is there a way
to ensure the date formating remains -- e.g., 6/14/2004.
Thank you,
Steve

 

[Michael Malinsky]

=CONCATENATE("today is ",TEXT(TODAY(),"mm/dd/yyyy"))

or

="today is "&TEXT(TODAY(),"mm/dd/yyyy")

When you concatenate a number, Excel does not recognize any formatting
associated with that number. Using the TEXT function, you can specify the
format for the number using the same methodology you would use in creating a
custom format in Format>Cells>Number.


--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

 

[Andy B]

Hi

Try this:
="Today is "&TEXT(TODAY(),"dd/mm/yy")

You might need to change the date/month around - as I'm in the UK!!

 

[papou]

Hello Steven
=CONCATENATE("today_is ",TEXT(TODAY(),""mm/dd/yyyy""))

Cordially
Pascal

 

[Steven Stadelhofer]

Pascal,
Thanks - it worked but I don't think you need 2 double
quotes around the mm/ddd/yyyy.
e.g.,
=CONCATENATE("Today_is ",TEXT(TODAY(),"mm/dd/yy"))

 

[Harlan Grove]

I was trying to develop a formula(function) in one cell
which would say... "Today is 6/21/04" ...I tried to use
the fomula above
=CONCATENATE("today_is ",TODAY())

...

Yet another alternative showing that no concatenation is needed.

=TEXT(TODAY(),"""today_is ""mm/dd/yy")