Make sure they are numerical, excel sort dates default by year/month/day, if
you want to sort by month/year and day you need to use a help column to
extract the months

=MONTH(A2)

copy down and select both columns and sort by the help column first, if you
get an error the dates are text


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Summer_Girl" wrote in message
...
Does anyone know how to sort dates my dd/mm/yyyy?
I have checked my regional settings and they co-ordinate, but it keeps
sorting by day regardless of the month.
Any suggestions would help!