Thread: Sorting and Selecting dates
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Sorting and Selecting dates
You could use a formula in a different cell:

=min(a1:a10)

The oldest date will be the smallest date.

kesslerjg wrote:

How do I select and display the oldest date in a column of dates.
--
kesslerjg

--

Dave Peterson
Reply With QuoteReply With Quote