stop counting in a cell when another has a date entered

[cbaatz]

i am working an excel file that i need the counter to stop after i enter date in another cell

G4 has date entered: 5-apr-19
H4 is the due date formula: =WORKDAY(G4,9)
I4 is counter: =TODAY()-H4
J4 is date completed: 9-apr-19

what i need is I4 to stop counting when J4 date is entered

 

[James006]

Hello,

In cell I4, you could test following:

=TODAY()-IF(J4="",H4,J4)

Hope this will help

 

[Peter_SSs]

Welcome to the MrExcel board!

what i need is I4 to stop counting ..

With what value?

.. when J4 date is entered

That is, what result do you expect for the sample data you gave?

 

[AGbert]

I just used the formula above for an HR tracking chart where I have to be aware of 2 different parts and it worked. Thank you.