Try this:
="Today's date is "&TEXT(TODAY(),"mmm/dd/yy")&" , and you're Late!"
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"A. Toczko" wrote in message
...
I was wondering if there is a way to mix text and a formula in a cell.
I'd
like to embed today's date (using the function =TODAY()) in the middle of
a
sentence. Thanks.
|