Hi

Assuming they are all valid Excel dates and not text representations of the
date then
=MIN(A1:A100)

Regards

Roger Govier


BJ wrote:
I need a formula that will look up the smallest date, and return it, from a
range of mixed dates.