Past due dates

[lkndllsgrl]

I have a sheet that I am trying to calculate days past due.

I=Date Due
J=Days Past Due
K = Date Implemented

I want to calculate the days past due, stopping counting once the date implemented is entered and I need to ignore blank cells. I have a formula that works to stop counting after the date implemented is entered, however it will not ignore blanks. If someone could help me modify the formula to ignore blank cells I would be forever greatful!

=IF(K3="",TODAY()-I3,K3-I3).

This formula ignores when there is no date in K, but returns a funky number if there is no date in I. How can I get it to not calculate if there is nothing input into I?

 

[Scott T]

Does this do what you want?

=IF(OR(I3="",I3>=TODAY(),K3<>""),"",IF(K3="",TODAY()-I3,K3-I3))