Earliest Date to populate?

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

Guest

Anyone,

I'm trying to gather a bunch of dates in an Excel spreadsheet row and have
the earlies date by itself just populate in a cell. Does anyone have a sample
formula to use?

It's racking my brain and driving me nuts!

Thanks!
 
Have you tried:
=MIN(A1:A10)

Just replace A1:A10 with your actual range of dates.
You might have to format the result as a date (otherwise you'll get a number
in the 38 thousand range)

Does that help?
 
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

Lookup MIN Date 6
finding the earliest date in an array of cells 6
Find Earliest Date 6
Earliest time in a range 3
Why are my dates show up as (example) 39538 in formula? 8
Looking for the earliest/latest date in a column 3
Earliest date using WEEKNUMBER 3
Entering date and time with a formula 1

Back
Top