how to sort cells by date?

i have a column of dates DD\MM\YYYY, i want to sort them by date .

i try:

 sort(A);

but it sorts them by days

how i can do this?

[Walter Roberson]

Is 11\5\2007 before or after 11/5/2007 ?

[Amr Hashem]

Are you joking? what do you mean?

Answer 1

[Walter Roberson]

[~, order] = datenum(A(:,1));
sortedA = A(order,:);

[Amr Hashem]

it gives me an error:

 Error using datenum
Too many output arguments.

I use:

 [ndata text alldata] = xlsread('defibrillator failures 98 to 10.xlsx','alldate');
[R2,C2]=size(alldata);
A=alldata;
[~, order] = datenum(A(:,1));
sortedA = A(order,:);

[Walter Roberson]

[~, order] = sort(datenum(A(:,1)));
sortedA = A(order,:);

[Amr Hashem]

Thanks... it works, but it didn't sort all of them.

as I discovered that some of dates written in the form "dd/mm/yyyy" and others "mm/dd/yyyy".

so it seems that I have to convert them first to one form.