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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Date in a cell equals most recent date in three other cells (https://www.excelbanter.com/excel-programming/427387-re-date-cell-equals-most-recent-date-three-other-cells.html)

Pete

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.

All times are GMT +1. The time now is 02:48 AM.