Finding the latest date represented in a group of cells
 

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.

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.

Finding the latest date represented in a group of cells
 

Yes! Thank you, I am going to try this formula right now. Thank you for your
post!!
Jennifer

"T. Valko" wrote:

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.

Finding the latest date represented in a group of cells
 

You're welcome!

Biff

"jennifer" wrote in message
...
Yes! Thank you, I am going to try this formula right now. Thank you for
your
post!!
Jennifer

"T. Valko" wrote:

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.