How do I include TEXT in the same cell with a FORMULA?

[Guest]

I have a cell containing the formula "=TODAY()" . This formula returns and
displays the current date in the cell. I want to ADD the TEXT "Today's Date"
to the SAME CELL without interfering with the functioning of the formula. Is
it possible to do this in Excel? If so, what is the procedure? THANKS in
advance to anyone who knows the answer and can post it here!

 

[PCLIVE]

Maybe something like this:

="Today's Date "&TEXT(TODAY(),"m/dd/yy")

HTH,
Paul

 

[Peo Sjoblom]

=Today's Date "&TEXT(TODAY(),"mm/dd/yy")

 

[Earl Kiosterud]

Format the cell (Format - Cells - Number - Custom, Type box):

"Today's Date" m/d/yyyy

Change the date formatting to suit.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...