In Epplus Convert String Date as Date in Excel
<p>I am dumping a string Date from DataTable to Epplus. I want to treat that date as Date in Excel. So that I can get Date Filter in Excel.</p>

<p>Things I tried,</p>

<ul>
<li>Passed that date as Datetime. Now, Excel takes it as date and gets a date filter. But, it affects the pivot</li>
<li>Passed it as string with req. date format, The excel takes it as string and does not gets the date Filter in excel.</li>
</ul>

<p>Hope i will get a solution from you guys. Any help will be appreciated. </p>