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


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!!!