determining the greater of three or more numbers

  • Thread starter Thread starter Darryl
  • Start date Start date
D

Darryl

I have three dates in three seperate cells. Can I create a formula in a
fourth cell comparing the dates and returning the greater of the three?

Example...

cell 1 cell 2 cell 3
1/1/09; 4/7/09; 3/18/09; What would the formula be to return 4/7/09?

using Excel 2003
 
=MAX(A1:A3)
If the 3 cells are A1:A3

Regards,
Stefi


„Darryl†ezt írta:
 
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

How to use index and match function for determining the value? 1
Formula help with greater than and count if 1
Find the position of a date 6
Counting average number of days between 2 dates 3
How to determine the highest occurrence? 4
Trouble Using Count Feature for Multiple Criteria 3
Percentage of dates that are 7 days late 3
Formula For Date Comparisons 2

Back
Top