View Single Post
  #3   Report Post  
Ragdyer
 
Posts: n/a
Default

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.