How to sort dates from Oldest to Newest in Excel?
<p>I have code that brings data in a database to Excel.</p>

<p>For it to be versatile the cells are formatted as "General". This worked.</p>

<p>Now someone wants to sort dates "Oldest to Newest" but the only option that shows up is A to Z or Z to A.</p>

<p>I followed all suggestions found in <a href="https://stackoverflow.com/questions/12375138/how-to-sort-by-dates-excel">How to sort by dates excel?</a>.  Going through all those steps I did see the proper sort appear, so I recreated the workbook to reproduce this but could not.</p>

<p>Why doesn't formatting the column as a date display the "Oldest to Newest"?</p>

<p>What steps are required to get the sort options to display "Oldest to Newest"?</p>

<p>I press F2 and it does not work.  I click on a cell in the original column that was general changed to date but it does not work.  I click on the column header in the original column that was general changed to date but it does not work.  I click on a cell in the new column that pasted values special but it does not work.  I click on the column header in the new column that pasted values special but it does not work.</p>