stop counting in a cell when another has a date entered

cbaatz

New Member
Joined
Oct 11, 2019
Messages
1
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

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hello,

In cell I4, you could test following:

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

Hope this will help
 

Forum statistics

Threads
1,085,925
Messages
5,386,804
Members
402,019
Latest member
JLuby

Some videos you may like

This Week's Hot Topics

Top