I wish to include today's date in a concatenated statement, but it always
shows up as the date number instead of the date. How do I show the date?

Instead of using TODAY() or a reference to a cell which contains TODAY(),
you need to embed it in a TEXT function, like:
="TODAY IS "&TEXT(TODAY(),"m/d/yy")&"."

Bob Umlas
Excel MVP

"Ken G." wrote in message
...
I wish to include today's date in a concatenated statement, but it always
shows up as the date number instead of the date. How do I show the date?

="Today's date is "&TEXT(TODAY(),"mm/dd/yyyy")&"."


"Ken G." wrote:

I wish to include today's date in a concatenated statement, but it always
shows up as the date number instead of the date. How do I show the date?

Hi!

It would have been better had you posted the formula.

Use this in place of TODAY():

TEXT(TODAY(),"m/d/yyyy")

You can change the "m/d/yyyy" format to whatever format you want:
"d/m/yyyy", "yyyy/m/d", "m/d/yy", etc.

Biff

"Ken G." wrote in message
...
I wish to include today's date in a concatenated statement, but it always
shows up as the date number instead of the date. How do I show the date?