Sorting by date order

[Guest]

How can I indicate in column 'B' for instance which date entry in column 'A'
is the oldest then next oldest and so on?

For example:

A B
18/7/06 3
18/7/06 3
11/9/06 7
1/9/06 6
14/8/06 5
19/9/06 8
5/7/06 1
10/7/06 2

Is this possible?
tia

 

[Pete_UK]

Assuming your data starts in A2, enter this formula in B2:

=RANK(A2,A$2:A$9,1)

Copy the formula down.

Hope this helps.

Pete

 

[Guest]

Thanks very much Pete. Job done.

 

[Pete_UK]

Thanks for feeding back.

Pete

Thanks very much Pete. Job done.