Need formula to stop a countdown between dates

[SophBooth95]

Hello,

Ive set up a tracking document which allows me to see the final date an order can be placed without causing further impact. However what im wanting to happen, is when the item has been actioned, it will stop the countdown of days

Lead Time (D) - how long the material is on
Required on site (F) - Date needed
Final Bulk Order Date (G) - =F8-D8
Countdown (I) - =G8-TODAY()

My idea is that if in column J has a status entered into it i.e. "Complete" it will stop column I counting down further. If it "Pending" it will continue to count down

Thanks

Element of Works (C)	Lead Time (Mat + Fab) (D)	Required on Site (F)	Final Bulk Order Date (G)	Outstanding Info (H)	Countdown (I)	Status (J)
Terracotta Tiles (Smooth)	126	03-Jan-24	23-Aug-23	C	2.00	Complete
Terracotta Tiles (Profiled)	126	03-Jan-24	23-Aug-23	C	2.00	Pending

 

[Anfinsen]

Please post the formula in cell I2. I think it needs to be amended to something like below.
=if(J2<>"Complete",'insert your current formula here',"Countdown Stopped")