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

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!

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

Maybe something like this:

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

HTH,
Paul

"NJCHAZ" wrote in message
...
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!

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

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


--
Regards,

Peo Sjoblom



"NJCHAZ" wrote in message
...
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!