Excel: Find latest date in a list

Popular categories

Dashboard reporting with excel This e-book teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.

Excel Worksheet-Formula Add-Ins allows worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.

Get Digital Help > Excel > Dates > Excel: Find latest date in a list

← Previous post -

Filed in Dates, Excel, Search/Lookup on Sep.01, 2007. Email This article to a Friend

Question: How to find the latest date in a list and the adjacent value?

Answer: To find the latest date, type

=MAX(A:A)

in a cell (C1).

To find the adjacent value, type

=VLOOKUP(MAX(A1:A26),A1:B26,2,FALSE)

in a cell (C2).

Download excel sample file for this tutorial.
find-latest-date-in-a-list.xls
(Excel 97-2003 Workbook *.xls)

VLOOKUP(lookup_value; table_array; col_index_num; [range_lookup])
Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default, the table must be sorted in ascending order.

MAX(number1;[number2];)
Returns the largest value in a set of values. Ignores logical values and text.

Find largest value in a table and return adjacent cell value

Lookup a value and find max date in excel

Find overlapping date ranges in excel

Create a unique distinct list from a date range in excel

Finding the nearest date in a range of dates using excel formula