title: DateTime problem when day <= 12
body: <p>I've looked around a lot and short of writing a horrible chunk of code to manipulate the string, I'd like to ask if anyone knows a nice way of sorting it:</p>
  
  <p>I have a bunch of date strings in cells that I'm pulling out such as:</p>
  
  <p>03/05/2011<br>
  27/05/2011<br>
  31/05/2011<br>
  03/05/2011<br>
  09/05/2011<br>
  31/05/2011<br>
  etc.</p>
  
  <p>While I'm reading any entires where the day can be construed as a month - i.e. entries 1, 4 and 5 above - it gets put in as a DateTime with the day and month swapped.</p>
  
  <p>For example, 03/05/2011 gets read in as a DateTime "05/03/2011 00:00:00"
  The others are all read and nicely provide me with a simple string of "27/05/2011".</p>
  
  <p>I'm getting this info from Excel, using </p>
  
  <pre><code>((Excel.Range)worksheet.Cells[rowCount, 3]).Value.ToString()
  </code></pre>
  
  <p>If I try Value2 as with my other lines, it reads those odd dates as things like "40607" but again, will read the other dates normally.</p>