title: Filtering Months with Criteria using AutoFitler (VBA)
body: <p>So theoretically, this concept for filtering dates by month should work, but it is not. I'm using a form that logs each assignment done, and then dates them with a standard format. I'm confused as to why this code is not working to count the dates in this form. Each month in the form will always be formated as x/xx/xxxx for single digit months, and xx/xx/xxxx for double digit months. In my mind, finding a cell that starts with the characters for each month and then counting them, should be a simple enough concept for my needs. The problem is that when it counts the rows based on this filter, it returns 0. Does anyone know what's going on?</p>
  
  <p>Thanks!</p>
  
  <pre><code> With iTable
          .AutoFilter
          .AutoFilter Field:=1, Criteria1:=tin
          .AutoFilter Field:=3, Criteria1:="=1/*"
          End With
          TData.Cells(i, 4).Value = iTable.Resize(, 1).SpecialCells(xlCellTypeVisible).Count - 1
  
  
          With iTable
          .AutoFilter
          .AutoFilter Field:=1, Criteria1:=tin
          .AutoFilter Field:=3, Criteria1:="=2/*"
          End With
          TData.Cells(i, 5).Value = iTable.Resize(, 1).SpecialCells(xlCellTypeVisible).Count - 1
  </code></pre>