Looking for the earliest/latest date in a column

S

soconfused

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?
 
R

RJ

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top