View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete Pete is offline
external usenet poster
 
Posts: 193
Default 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.