title: Extract months from start and end date in VBA - Excel
body: <p>I have a list of dates, derived from a start and end date, for eg:</p>
  
  <p><code>01/10/2011</code> - through to.. - <code>01/01/2012</code></p>
  
  <p>In VBA, how can I retrieve an array of months from between these two dates, so the output would be similar to:</p>
  
  <pre><code>Oct-2011
  Nov-2011
  Dec-2011
  Jan-2012
  </code></pre>
  
  <p>Is there an easily solution for this?</p>