View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
esilverb esilverb is offline
external usenet poster
 
Posts: 7
Default find the most future date

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.