None of the above worked for me. My dates were well-formatted and the date format was set properly.
The key in my case was "my data has headers
" checkbox. After I unchecked this option the ordering function just started to work fine.
This function is available under the "Custom sort
" option.
ps. I can accept that the first some row was ordered in a wrong way because of this option but I have no clue about why at the middle of my range was ordered on the wrong way. Excel makes me crazy...