return the greatest value in a range of cells

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

I have a list of dates and I want a function that will return the latest date
in the list. Is such a thing possible?
 
be sure the cells are formatted as dates, then use the formula "=MAX(range)".
 
Check out Excel help for the MAX function.

I have a list of dates and I want a function that will return the latest date
in the list. Is such a thing possible?
Click to expand...
Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins
 
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

Finding the greatest value 4
Excel Trying to code an Array Function in VBA Excel to works as a MaxIF 3
Finding Data in a range 3
SUMPRODUCT - enhanced formula 1
What is a formula for finding the largest date in a list of dates? 3
Advanced 'SUMPRODUCT' formula - MAX or LARGE?? 4
Compare Cells of Text and Return Highest Value based on a Customiz 1
greatest value function? 2

Back
Top