Substitute the range in the example for the cell range of your dates:

=MAX(A1:A10)
--
Kevin Backmann


"esilverb" wrote:

I have a list of dates that I keep adding to. In a selected cell, I want to
show the date most out into the future. Ex: in the column are the dates
9/30/08, 9/2/08 and 8/31/08. In the designated cell I want a formula or code
that will look at these three dates and put 9/30/08 into the cell. If I add
10/2/08 to the list, I want the desginated cell to have 10/2/08 in it.
Thanks for your help.