Count Days until Completion

P

Pat

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
 
B

Bernard Liengme

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(B2>0, (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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count dates until complete or Cancel 5
if date has Saturday or Sunday in it need to add 2 or 1 to date 2
Calculating calendar days and completion dates. 4
Comparison of columns using Conditional Formatting 3
calculating # of days 1
Help with macro 2
minimize repeating query criteria & generating monthly YTD totals 1
Account aging formula using workdays M-F 2

Top