Perhaps some of your values are text and some are real dates?
=ISTEXT(cellref) and =ISNUMBER(cellref) will tell you.
--
David Biddulph

Grant wrote:
with my column formated for date I cannot seem to sort it .I enter
gas costs with random dates for a period of a year then when
finished enterintg data I try to sort it in date order and it will
not give me a logical sort