View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
soconfused soconfused is offline
external usenet poster
 
Posts: 93
Default Looking for the earliest/latest date in a column

Thank you so much. I've been struggling for a couple of hours with this.
--
DMM


"Toppers" wrote:

Earliest

=MIN(A:A)

Latest

=MAX(B:B)

HTH


"soconfused" wrote:

I have a spreadsheet that has 2 columns of dates. In the first column, I
want to find the earliest date and in the second column, I want to find the
latest date. Is there a function within excel that will find that
information for me?
--
DMM