Days Past Due remain blank

[krisking64]

I'm hoping you can help.

PO Date is F2, Due Date is G2, and Received Date is I2.

I currenty have =IF(ISBLANK(I2),TODAY()-G2,I2-G2) as my formula in H2 so it will stop counting once I enter a received date. However, I do not want to a negative number in H2 if the due date has not arrived yet. I had =IF(DAYS360(G2,TODAY())<1,"",DAYS360(G2,TODAY())) in H2. This formula would leave a blank in H2 if the due date had not been met but it would not stop counting.

What is the best way to resolve this issue?

 

[Marcílio_Lobão]

krisking64, Good afternoon.

Try to use:

=IF(G2="", "", IF(ISBLANK(I2), TODAY()-G2, I2-G2))

Is that what you want?
I hope it helps.

 

[krisking64]

Thank you for your help.

The formula you provided did not make a difference. I still have a negative number in H2.

 

[krisking64]

I found the issue,

the follow should read as follows:

=IF(I2="", "", IF(ISBLANK(I2), TODAY()-G2, I2-G2))