Stop A Formula From Calculating When Another Cell Contains Specific Text

[Larnee]

Hi Guys,

I am needing to stop a formula from calculating if another cell contains specific text. Below is a snippet of the sheet I'm currently working on.

For example, I am needing the formula in $G22 =IF([@[DUE DATE]]="","",([@[DUE DATE]]-TODAY())) to stop calculating when cell $H22 contains "Completed". I would like to keep a record of the amount of "Days Left" from when the word "Completed" is selected from the drop-down list in cell $H22.

Thanks in advance!