title: Excel auto filter
body: <p>I have a problem while filtering the Excel column by year. I tried the below code but didn't get any success, could anybody help me or offer some suggestions on how I can find the year in excel filters.</p>
  <p>For example, if I enter '12/30/2016', it will search successfully but I would like to search by year (e.g. '2016').</p>
  <pre><code>Excel.Range range = WorksheetSource.UsedRange;
  range.AutoFilter(29, tByear.Text, XlAutoFilterOperator.xlFilterValues,test4[0,0], true);
  range.AutoFilter(29, tByear.Text, Excel.XlAutoFilterOperator.xlOr, tByear.Text+ &quot;*&quot;, true);
  </code></pre>