Tom’s Tutorials For Excel: Lookup Oldest and Newest Date
The picture shows one way of obtaining the oldest and newest dates in column B that correspond to the person’s name in column A that is in cell D2 as a lookup criteria. Because dates are numbers, you can use the
MIN function for the oldest date, and the
MAX function for the newest date.
The formula in cell E2 for the oldest date is
The formula in cell F2 for the newest date is