Hi

This is my first post on the forum, i'm really stuck with a formula and i hate give in. We are currently using this one =IF(ISBLANK(R9),TODAY()-B9,R9-B9) to stop a clock countdown if a date is entered in R5, (B9 is the date of referral). What i would also like to do is apply an additional condition that if an *** date is added in Cell J5, for example, the clock also stops as they would not be allocated someone there is no worry of having conflicting information in cells. I have looked at array formulas but can't quite get it to do what i would like it to do.

Any help would be greatly appreciated.