Hi

If the dates are recognised Excel dates, they will sort correctly. It sounds
like yours are not, though. Post a sample bit of data to show what
information you have in the cells.

Andy.

"pusimani" wrote in message
...
I have created a data in excel in which one column contains data. I want
to
sort the data with respect to the dates entered in the column. It does
sort
but the dates are neither in ascending or in descending order. the sorting
is
based on the rules of sort in excel. I need the sorting out by date.