IF Statement that looks at different conditions

[maddogg126]

I am currently trying to get the number of days past due for outstanding invoices. My formula works for most but when it gets to invoices that are not due yet, it is giving me negative numbers when I am looking for a zero.

The formula is below. If the current due date (column J) is not past due, how do I have the formula return a zero value?

 

[dreid1011]

Add MAX to whichever calculation it is that is providing the negative result. IE:

MAX(0,K62-J62) or MAX(0,TODAY()-J62). Or both if they both should not show a negative result.

 

[maddogg126]

Thank you!!

 

[dreid1011]

Thank you!!

You're welcome, and happy to help.