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... 
=IF(A3="", "",A3 - TODAY())
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