Combine text and today's date in a cell

[Sheila]

Is it possible to add today's date and text in a cell? Can I please have the
formula?

 

[Ron Coderre]

Try something like this:

="Today is: "&TEXT(TODAY(),"MMMM DD, YYYY")

If today is August 29, 2006
that formula returns: Today is August 29, 2006

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Dave F]

=concatenate(TODAY(),"MMMM DD, YYYY")

 

[Gord Dibben]

Couple of examples

="this file was created on: " &TEXT(Creadate(),"mmmm d" &"," &"yyyy")

=B1& " " &TEXT(C1,"mmmm d" &"," &"yyyy") where B1 contains text

And one more to have text, date and a an amoun in the cell.

="Payment due " &TEXT(H15,"mmmm, d yyyy") & " " & TEXT(I15,"$#,##0.00")


Gord Dibben MS Excel MVP

 

[Gord Dibben]

and a an amoun in the cell.

How about "and an amount in the cell"<g>

Gord
Gord Dibben MS Excel MVP

 

[Gord Dibben]

And this returns what?

Perhaps you left something out?


Gord Dibben MS Excel MVP

 

[Sheila]

Thank you. It worked.

Try something like this:

="Today is: "&TEXT(TODAY(),"MMMM DD, YYYY")

If today is August 29, 2006
that formula returns: Today is August 29, 2006

Does that help?
***********
Regards,
Ron

XL2002, WinXP