arranging dates in chronological order

  • Thread starter Thread starter Jase
  • Start date Start date
J

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
 
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
 
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.
 
Back
Top