I use the following VBA code to sort a list of dates in ascending order.
Range("A1:B10").Sort Key1:=Range("A1"), _
Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
The problem is that in some cells in the date column, the...