title: Excel VBA - Convert Date String to Date
body: <p>I have a number of strings in cells which are dates but they need to be converted to date format.</p>
  
  <p>They are in the following format:  </p>
  
  <pre><code>mmm dd, yyyy
  </code></pre>
  
  <p>For Example:  </p>
  
  <pre><code>Feb 10, 2016
  </code></pre>
  
  <p>So they can be 11 or 12 in length:  </p>
  
  <pre><code>Feb 1, 2016
  </code></pre>
  
  <p>I have started writing a function to parse each part of the string individually (day as integer, month as integer and year as integer) to then convert into date format.</p>
  
  <p>Firstly, is there an easier/slicker way to do this than the above?</p>
  
  <p>If there isn't an easier way, what's the best was to convert the 3 letter month (e.g. Feb or Mar or Apr) into a month number (e.g. 2 or 3 or 4)? As that is the only bit I'm really stuck with.</p>