title: Insert today's date with button, as date, not function?
body: <p>I use this VBA:</p>
  
  <pre><code>ActiveCell.FormulaR1C1 = "=NOW()"
  ActiveCell.Offset(1, 0).Range("A1").Select
  </code></pre>
  
  <p>But the value of the cell becomes <code>=NOW()</code>, not the date. </p>
  
  <p>I want to push the button and get <em>2015-03-13</em>, and when I open the sheet tomorrow, it should still say <em>2015-03-13</em>.</p>