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