title: What's the best logic to return TRUE in VBA if month NAMES are 1 apart?
body: <p>I want to return <code>True</code> for the following examples:</p>
  
  <p><strong>Example 1</strong>  </p>
  
  
  
  <pre class="lang-none prettyprint-override"><code>Date 1: 7/31/14   
  Date 2: 8/1/14
  </code></pre>
  
  <p><strong>Example 2</strong>  </p>
  
  <pre class="lang-none prettyprint-override"><code>Date 1: 12/31/07  
  Date 2: 1/1/16      (notice one year is 2007)  
  </code></pre>
  
  <p>and <code>False</code> for the following example:</p>
  
  <p><strong>Example 3</strong>  </p>
  
  <pre class="lang-none prettyprint-override"><code>Date 1: 7/31/14
  Date 2: 9/1/14
  </code></pre>
  
  <p>What is the smartest way to go about this? I know I can use the <code>Month()</code> function and test whether the months are either different by <code>1</code> or <code>11</code>, but that seams like a bad solution</p>