title: excel autofilter using xlAnd and xlOr
body: <p>I know I can technically only have two criteria with Autofilter.</p>
  
  <p>I also know I can use an array to "add" more to an "And" or "Or" situation.</p>
  
  <p>Example I found:</p>
  
  <pre><code>             Range("A1").CurrentRegion.AutoFilter _
               Field:=1, _
               Criteria1:=Split("France#Belgium#Germany", "#"), _
               Operator:=xlFilterValues
  </code></pre>
  
  <p>However, I want to filter a column to all fields between two dates (one year) and include blanks.</p>
  
  <p>There has to be a better way than making an array of every date for an entire year like I am thinking....?</p>
  
  <p>This is one variation I have tried that doesn't work...</p>
  
  <pre><code> Range("A1:AV1").AutoFilter Field:=5, Criteria1:="=", Operator:=xlOr, Criteria2:="&gt;=1/1/2018", Operator:=xlAnd, Criteria3:="&lt;=12/31/2018"
  </code></pre>
  
  <p>Help! Please!
  Thanks,</p>