title: How to make match() work with date in excel vba?
body: <p>I'm having problem making the match() work in excel VBA. The code is:</p>
  
  <pre><code>x = Application.Match("Sep 2008", Range("F1:F1"), 0)
  </code></pre>
  
  <p>The value in cell F1 is 9/1/2008.</p>
  
  <p>Even if I changed Sep 2008 to 9/1/2008, it still doesn't return any value.</p>
  
  <p>Any idea how to fix it?</p>