| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date in a cell equals most recent date in three other cells | Excel Programming | |||
| 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 | |||
| 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) | |||
Linear Mode
