=CONCATENATE("today_is ",TODAY())

  • Thread starter Thread starter Steven Stadelhofer
  • Start date Start date
S

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
 
=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
 
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!!
 
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"))
 
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())
Click to expand...
...

Yet another alternative showing that no concatenation is needed.

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