View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Finding the latest date represented in a group of cells

Latest meaning most recent?

=MAX(A1:C1)

Latest meaning oldest?

=MIN(A1:C1)

Biff

"jennifer" wrote in message
...
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.