title: VBA Excel - Filter multiple fields
body: <p>I'm trying to filter three column. Please see the following code:</p>
  
  <pre><code>.Range("$A:$S").AutoFilter field:=1, Criteria1:=Array("Ongoing", "Completed"), Operator:=xlFilterValues
  
  .Range("$A:$S").AutoFilter field:=4, Criteria1:=Array("AQs", "Prop", "RF", "RP", "SQs"), Operator:=xlFilterValues
  
  .Range("$A$1:$S$" &amp; ActiveSheet.UsedRange.Rows.Count).AutoFilter field:=10, Criteria1:="&gt;" &amp; _
    Format(Date - 7, "mm/dd/yyyy"), Operator:=xlOr, Criteria2:="=Not Known", Operator:=xlOr
  </code></pre>
  
  <p>Basically, i'm filtering field 1 based on 'ongoing' and 'complete'; field 4 on 'aqs', 'prop', 'rf', 'rp', etc. Finally i want to filter all of that for dates within a week of now AND the value 'Not known'.</p>
  
  <p>It filters through the first two fields fine... but the last filter line doesnt work correctly. I get the 'Not Known' values and i get everything that is within a week of today BUT i dont get anything which is in advance of today... this is a problem.</p>
  
  <p>Can anyone help?</p>