title: What is the recommended way to insert current date in an Excel cell, as a constant?
body: <p>I have been using the following code:</p>
  
  <pre><code>private void InsertDate(string dstCoordinates)
  {
      Range dstRange   = worksheet.get_Range(dstCoordinates);
      dstRange.Formula = "=TODAY()";
      dstRange.Locked  = true;
  }
  </code></pre>
  
  <p>Which re-evaluates the date every time the spreadsheet file is opened.</p>
  
  <p>But now I need the date to be evaluated once, when it is inserted in the cell. From that moment on, the value should remain constant.</p>
  
  <p>That value seems to be stored internally as double.</p>
  
  <p>Perhaps what I need is a function as follows:</p>
  
  <pre><code>string today = ExcelEvaluate("=TODAY()");
  dstRange.value2 = today;
  </code></pre>
  
  <p>Is there such facility?</p>
  
  <p>TIA</p>