Stop a countdown when the issue is resolved

Question

Hi there, I am creating a vulnerability tracker for my work. We have a time limit of 14 days to resolve said vulnerability/issue from the date it is published.

So far I have created this table:

A	B	C	D	E	F	G	H	I	J	K
Name of Vulnerability	Patch Update Release date	Date to be remediated by	Days left to Remediate	Remediated within 14 days?	Within Patch Cycle?		Ticket Number	Date Ticket Raised	Date Ticket Closed	Ticket Outcome
TE S T ER	16/09/2024	30/09/2024	10		Yes		######	/	/	Ticket to be Raised
TE S T ER  2	01/09/2024	15/09/2024	-5		No		######	/	/	Remediated

I want to know if its possible to stop the countdown that happens in row D when I put 'Yes' in row E?

I'm guessing it's an 'IF statement' but I am not very good with those....any help would be appreciated, thank you :)

Answer 1

That could be something like:

=IF(E2="Yes", "", count_down_formula)

and copy it down column E as far as needed.