Bob,

assuming your list of dates is in A2:A30, then in B2 type:

=Rank($A2,$A$2:$A$30,1)

and copy this formula down to B30. It show's the position of the value in A2
within the array of values in A2 to A30. The ",1" at the end makes it rank in
ascending order as the default is desending.

Cheers, Pete

"BOB" wrote:

I have a range of dates in one column, I need to prioritise against these
dates. For example, in order to define a priority if I have a date of the
12/02/05 and a date of the 25/03/05, then the earlist date is a priority 1
etc. There are around 30 different dates, so the priority number will go up
to 30 (in this case, where the same date exists they will have the same
priority number). Does anyone know of a way of doing this?

Thanks