adding on formulas in a worsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to insert a formula which sort out the dates entered in an ascending order automatically which ever one is entered first can someone assist me please, many thanks
 
Hi,

Assuming your dates are contained in Column A:

B1, copied down:

=SMALL(A:A,ROW(B1))

Hope this helps!
 
Back
Top