IF Statement in excel for a date
 

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

IF Statement in excel for a date
 

Dates are just numbers formatted to look like dates so the MIN() function
will return the earliest date:

=MIN(A1,C1,D1,F1)

or whatever your cells are.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"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

IF Statement in excel for a date
 

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