In the first instance it seems they are being sorted alphabetically, so
are treated as text rather than dates. Does the cell display change if
you format the cell with another date format or change it to a number
format?
what is the default date format on the computer you are using within
your operating system? Is this effecting you.
You probably need to look at the datevalue or date functions to convert
your dates to the required format
Regards
Dav
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=560142