Looking for the earliest/latest date in a column
 

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

Looking for the earliest/latest date in a column
 

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

Looking for the earliest/latest date in a column
 

Here are the funtions you should use:

First Column (I will use column A in my example)
=min(A:A)
Second Column (I will use column B in my example)
=max(B:B)

"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

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