arranging dates in chronological order

[Jase]

I have a column of dates and new dates always get added at the end so they
are not in chronological order. I want to write a function that will
automatically arrange all the dates in chronological order in a new column.
Is this possible?

Jase

 

[Gary''s Student]

Are there duplicates in the dates?

 

[Jase]

MMM no but a small possibility there could be. I also didnt want to have to
push a button to do this i wanted a function that would auto do this.

thanks

 

[Gary''s Student]

Say we have dates in random order in column A. In B1 enter:

=IF(ISERROR(SMALL(A$1:A$3000,ROW())),"",SMALL(A$1:A$3000,ROW())) and copy down

1. you must format col B to Date
2. adjust the 3000 to suit your needs.