|I had a chance to look at your speadsheet.|
When I opened it in Excel 2003 (the only version I have access to at this time) Column B looked like this:
I'm assuming that I do not get any entries that start with YYYY because the date setting in my Regional and Language Options control panel is set to MM/dd/yyyy.
Using the ISTEXT function, I found that everything from 1/1/2005 (B9) and below are text values, not dates. Row 9 is also the row where your other data goes from all upper case to mixed case, so I assume that this data was pasted from some other source.
When I tried to sort the data on Column B (Doe) Excel popped up a message that said:
The following sort key may not sort as expected because
it contains some numbers formatted as text:
What would you like to do?
O Sort anything that looks like a number as a number
O Sort numbers and numbers stored as text separately
When I choose the first option (Sort anything...) it sorted them fine.
So, as Mike suggested a while back, some of your values are dates and some of them are text strings.
To convert the text strings to dates, this worked for me:
1 - Select an empty cell
2 - Ctrl-c to copy
3 - Select the values in the Doe column (Both dates and the text strings)
4 - Right Click...Paste Special...Add (All values should change to a 5 digit number)
5 - Format the values in any date format you'd like
6 - Sort
Since Excel would "prefer" to work with numbers instead of text, it will attempt to add zero to the "numbers stored as text" and convert them to numbers. Once they have been converted, they can be formatted as dates.
You should also be able to convert the text values to dates by doing this:
1 - Enter this formula in Row 4 of an empty column and drag it down:
2 - Right Click...Copy...Right Click...Paste Special...Values
3 - Format the 5 digit numbers in any date format you'd like
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.