Try this:

=IF(COUNT(A2:C2),MIN(A2:C2),"")

Format as DATE

Biff

"T Miller" wrote in message
...
If I have this and I want to have the earliest date in the cell how do I
set
up the IF statement?

Member Kick off Call Date Data Received Date MT Data Lock Date Date
9/22/06 10/9/06 11/8/06

I want the outcome in the column "Date". and I want it to read 9/22/06
since that is the earliest date. Does this make sense?
--
Thomas