Make sure that the column contains dates and is not formatted as date...

To test, change the cell format to number... it should show 39971 if the
date in the cell was 7th June...

"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