Not sorting dates properly

**lstar** · 07-07-2015, 03:31 PM

I am trying to sort a sheet changing in length by date however, there are dates from 2012 and 2014 showing up first and then it is sorted correctly.

Please Login or Register  to view this content.

**amartinez988** · 07-07-2015, 03:36 PM

Can you post the workbook so we can see?

**lstar** · 07-07-2015, 03:52 PM

I can not post the workbook at this time. But I have updated some code and it is still not working properly.

Please Login or Register  to view this content.

**MrShorty** · 07-07-2015, 04:06 PM

The usual first culprit for something like this is having "dates" that are actually text strings instead of real dates. The first thing I would check is if all of the dates in the column of interest are real dates or if they are text strings (the =ISTEXT() function can be useful in this task).