How do I find the earliest date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of dates that range anywhere from 10/1/2006 to the current
day. I know I can put a filter on that column and the list will show me the
earliest date in the drop down, but I'd like to skip that step and have the
earliest date from the list of dates appear automatically in another cell.
Any suggestions???
 
Use

=MIN(Date_Range)

format as date if you get a large serial number
 
You must log in or register to reply here.

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

Similar Threads

Return earliest date 3
How to find earliest record based on unique identifier from a list ofdata 4
Can Excel return the earliest date from a list? 2
Choosing a date from a list based on two criteria 2
Find earliest date combined with status 2
Find top date for unique fields 1
extracting earliest date (age) from list 1
SORTING A COLUMN BY DATE 6

Back
Top