Hi!

I need a formula that will look up the smallest date

What's a "small" date? <g

Do you mean the oldest date?

=MIN(A1:A10)

Biff

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