You could SORT your data using Data Sort and using your Date column as
the key and setting it for Decending sort............or, if you only wanted
to know what date was the latest and leave the data sorted as it is, then you
could put this formula in any convienient cell, adjusting for your specific
range.....

=MAX(A1:A100)

Vaya con Dios,
Chuck, CABGx3



"Nikki Q" wrote:

I want to format a column so that the date that is most current moves to the
top of the column. Is this possible and if so how? I am logging legal due
dates and they vary. Please help!!!