Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate Cell with another cell, but only if the date equals today | Excel Worksheet Functions | |||
How to: date field minus minutes equals new date | Excel Worksheet Functions | |||
IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
Newbie Date cells so most recent is on top | Excel Worksheet Functions | |||
How do I create a formula that inputs the date when a cell equals. | Excel Discussion (Misc queries) |