Include date in concatenate statement

K

Ken G.

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?
 
B

Bob Umlas

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
 
B

Biff

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
 
Top