title: How to concatenate string with DATE()?
body: <p>In Excel, I'm trying to have a cell look something like:</p>
  
  <p><code>by no later than August 27, 2012</code></p>
  
  <p>When I try to concatenate a string with a <code>DATE</code>, for example:</p>
  
  <p><code>="by no later than " &amp; DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))</code></p>
  
  <p>I get an output like this: </p>
  
  <p><code>by no later than 41118</code></p>
  
  <p>How can I get a date to show up instead of an integer?</p>