Finding the latest date represented in a group of cells

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

Guest

I have a worksheet that has 3 columns of dates represented. I am trying to
write a formula to give me the latest of those three dates. I have been
trying the IF formula with two calculcations and I think I am missing
something.
 
Latest meaning most recent?

=MAX(A1:C1)

Latest meaning oldest?

=MIN(A1:C1)

Biff
 
Yes! Thank you, I am going to try this formula right now. Thank you for your
post!!
Jennifer
 
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

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
rerturn latest date 1
counting dates using SUMPRODUCT 4
Financial rear date ranges in a single cell 2
Show latest date in a column 1
If/Then Formula Using Dates 1
Excel Help with dates 2
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2

Back
Top