multiple =if

**mojobaabby** · 12-13-2009, 04:18 PM

ok here is one for you...
I have 3 columns
"A" Planned install, date is entered manually for the day install is to happen
"B" Install date, date the install is actually completed
"C" Expected install, should show the same date as planned install.

this is inserted into "C" currently, =if(B4>0,A4," ").

How do I make the date in cell "C" stay if it's after the date entered in "B" install date, and clear the cell if the date entered in "B" install date is the same as or earlier than date entered?

the purpose is to see which of my 14 crews is not making target dates
hope all this makes sense!!
thanks

**darkyam** · 12-13-2009, 04:24 PM

Not quite sure I understand, but perhaps =IF(B4>A4,A4,""). That would cover the case where B4 is blank as well.

**teylyn** · 12-13-2009, 04:27 PM

Hi,

maybe

=if(and(today()>B4,B4>0),A4,"")

this also compares today's date with B4 as well

Is that what you need?

**mojobaabby** · 12-13-2009, 04:36 PM

thanks for the info.
I just need to make sure that cell "c" stays clear if the date entered in column "b" is the same as or before the date entered into column "a".
That way i can quickly see which customers have not met the install date. If the date entered in "a" shows up in "C" i will know it was late and can compare the actual date in "b" to see how late.
hope that makes more sense