title: Filter Dates Between Two Specific Dates In an Excel Column using C# Interop
body: <p>Just trying to filter a column in Excel using c#.<br>
  My Focus is to filter a column based on Two Dates.</p>
  
  <p>Input_1 : From date (dd-mmm-yy) eg: 01-Dec-18 </p>
  
  <p>Input_2 : To date (dd-mmm-yy) eg: 10-Dec-18 </p>
  
  <p>The Excel Column contains random dates in dd-mm-yyyy (eg: 07-11-2018)</p>
  
  <p>How is it possible to apply a filter in this column so that I can get the Column Dates modified within the Dates mentioned as Input_1 and Input_2</p>
  
  <p><a href="https://i.stack.imgur.com/mbo9E.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mbo9E.jpg" alt="enter image description here"></a></p>
  
  <p>What I tried to apply a filter to column :  </p>
  
  <p><code>excelRange.AutoFilter(excelDATESColumn_Number,FromDateInput_1,Excel.XlAutoFilterOperator.xlAnd,Missing.Value, true);</code></p>
  
  <p>Still no help!
  I am starting to think, it is not possible via Interop to do this!!</p>