I am sorry I did not make myself clear. To find the oldest date, we need to
know how to interpret the year.

If the formula sees:

111140

It can either interpret this as November 11 1940 or November 11 2040.


If the formula sees:

122550

It can either interpret this as December 25 1950 or December 25 2050.


If you (the human) look at a piece of data, you determine the correct
century by applying some "rule".

The formula must be designed with the rule in mind!
--
Gary''s Student - gsnu200783


"joeb" wrote:

Dates are formated as text (i.e. "031597" for March 15, 1997 or "040806" for
January 8, 2006) in a row - let's say in columns B and C. I need the oldest
date from the row.