title: Specific Date Filter in Macro
body: <p>Below is my code for specific date filter from 01-02-2018 to 10-02-2018.
  I don't get runtime error but it filter from 01-01-2018 until 14-02-2018.</p>
  
  <p>I have A to P column and n no.of rows also dates were in J column</p>
  
  <pre><code>Sub Date_Filter()
     Dim WeekS As Date
     Dim WeekE As Date
     WeekS = "01-02-2018"
     WeekE = "10-02-2018"
  Range("A1:P1").AutoFilter
          Selection.AutoFilter Field:=10, Criteria1:="&gt;=" &amp; WeekS, Operator:=xlAnd, Criteria2:="&lt;=" &amp; WeekE
  End Sub
  </code></pre>