Stop column X counting days from Today() IF Column Y has One of Three words in it

Hello folks,

I'm not sure if this is even possible in Excel but I've been trying for over an hour and have had no luck.

I've created a very simple formula which counts the number of days from today and excludes blanks. I'm trying to set it up so the formula *stops* counting once the words "Completed or Semi Completed" are in Column C. Column C will be a drop down menu if that changes anything.

Formula so far...

Please Login or Register  to view this content.

It looks like this http://i.imgur.com/3qm5V.png

Also is there a way I can stop the Days column having the - symbol and is there a way I can format the number to Bold and change the colour to Red

As stated, I don't think it can be done with formulas. VBA code could do it, but might I suggest that you enter the end date instead of the word 'Complete'. You could then use a simple formula to calculate the elapsed time.

-Rich

Thanks for the reply, Dangelor.

I've just googled and found a very similar problem to mine which seems to be solved without the use of VBA. The only difference is that the cell stopped counting if the column had been populated with anything, I have multiple values.

If this definitely unsolvable?