Date in a cell equals most recent date in three other cells
 

I am trying to make the date in cell A2 automatically equal the most recent
date which appears in cells B2, C2, and D2. Is there a way to write a
formula so the date automatically appears in cell A2?

Any help appreciated.

Date in a cell equals most recent date in three other cells
 

Easy formula. Tiny trick.

=MAX(B2:D2)

Tiny trick is to format A2 as date.
--
Gary''s Student - gsnu200848


"Pete" wrote:

I am trying to make the date in cell A2 automatically equal the most recent
date which appears in cells B2, C2, and D2. Is there a way to write a
formula so the date automatically appears in cell A2?

Any help appreciated.