Excel VBA - Convert Date String to Date
<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>