I have a table with dates in Column A (and they are dates and recognized and stored in memory as dates by Excel)
Proof that Excel (2016) is recognizing them as dates, I tried converting the value to a date with a
DATEVALUE() call, but it shows that the value is stored in memory as an Excel date:
This is the terrible sort that Excel is choosing when I attempt to sort by Oldest/Newest by right clicking on a "10-Jun" field:
Another issue/bug/side-effect is that when I attempt to change the format, it ignores my changes.
This issue is very odd and I'm not sure if I found a bug in Excel, however it's currently ruining my graphs. :(