I am needing help to add ONE layer to this IF formula.
It’s for an invoicing tracking base.
Overall, we are looking at 2 columns.
I found this super epic IF Formula here on the forum and need help.
*This first part I need help with - If the Paid Date exists = PAID
(the rest, the formula I have works)
If the Invoice Due Date is same day = DUE TODAY
If the Invoice Due Date is within 5 days = PENDING
If the Invoice Due Date is 5+ days = UPCOMING
If the Invoice Due Date is past = PAST DUE
Here is a pic of the columns I am working with
Here is the formula I am working with, I am fairly sure I need to change the first layer??