ExcelBanter - Search for most recent date from list of dates

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Search for most recent date from list of dates (https://www.excelbanter.com/excel-discussion-misc-queries/31992-search-most-recent-date-list-dates.html)

Wendell

Search for most recent date from list of dates

I need to populate a cell with the most recent date from a range of cells
with various dates. How do I do this? Any help?

Flintstone

Try this:

=LARGE(A1:A20,1)

Matt

--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=381399

All times are GMT +1. The time now is 05:27 AM.