Since you're having difficulty getting the formatting to work I'd guess
these dates are just text. I'd do everything I could to get these dates
as proper dates, either by converting them within excel, or by changing
the way the data gets into Excel. Sorting them is then dead easy.
Could you post a sample file and relevant code at thecodecage.com?


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=130283