adding on formulas in a worsheet

G

Gege48

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
 
D

Domenic

Hi,

Assuming your dates are contained in Column A:

B1, copied down:

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

Hope this helps!
 
Top