Date in a cell equals most recent date in three other cells
Thanks - does exactly what I need it to do.
Pete
"Gary''s Student" wrote:
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.
|