Is there a way to count days (with a date enter in Start Column) until
"Completed" or "Cancel" is entered in my Status Column?

Right now, it is calculating on the Start and Completion Date. If the
completion date is blank - I receive wrong date in the duration column.

Start Date: 4/1/10
Completion Date: 4/5/10
Status: Completed
Duration: 4


--
pls

Let's say your stuff is in A1:B4 with labels in A;
In B4 to compute duration we could use any of these
A) =IF(B20, (B2-B1),"") or=IF(B2, (B2-B1),"") since a positive value in
B2 will be treated as TRUE
B) =IF(OR(B3="Completed",B3="Cancel"), B2-B1, "")
C) =IF(LEFT(B3)="C",B2-B1,"")
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Pat" wrote in message
...
Is there a way to count days (with a date enter in Start Column) until
"Completed" or "Cancel" is entered in my Status Column?

Right now, it is calculating on the Start and Completion Date. If the
completion date is blank - I receive wrong date in the duration column.

Start Date: 4/1/10
Completion Date: 4/5/10
Status: Completed
Duration: 4


--
pls

Pat penned:
Is there a way to count days (with a date enter in Start Column) until
"Completed" or "Cancel" is entered in my Status Column?

Right now, it is calculating on the Start and Completion Date. If the
completion date is blank - I receive wrong date in the duration column.

Start Date: 4/1/10
Completion Date: 4/5/10
Status: Completed
Duration: 4


If the start date is in A1 the completed Dated in B1 in C1 put

=IF(OR(B1="",B1="cancel"),"",B1-A1)

and format C1 as a number

--
Steve

I think age is a very high price to pay for maturity.
- Tom Stoppard