title: C# getting excel value date
body: <p>I need to retrieve an excel column of date.
  My first column 'A' values are formatted like this<code>6/20/2016 10:44</code>. I have no problem of retrieving column 'A' with this format using </p>
  
  <pre><code>using DocumentFormat.OpenXml;
  
  double d = double.Parse(theCell.InnerText);
  DateTime conv = DateTime.FromOADate(d).Date;
  </code></pre>
  
  <p>My second column 'B' is formatted as <code>6/20/2016.</code> With no time, just date.
  but my problem is when i tried this code below:</p>
  
  <pre><code>using DocumentFormat.OpenXml;
  
  double d = double.Parse(theCell.InnerText);
  DateTime conv = DateTime.FromOADate(d).Date;
  </code></pre>
  
  <blockquote>
    <p>theCell.InnerText value is 1455</p>
  </blockquote>
  
  <p>I am having a different value. the value changes into <code>12/25/1903 12:00:00 AM</code></p>
  
  <p>How can I retrieve excel values with this kind of date format <code>6/30/2016</code> ?</p>