Complex If Statement

ok... sorry again... it was my birthday, so i was taking an excel vacation.

so, if a planned payment date is before the due date it shows both.... hmmm... i hadn't thought of this before... companies don't usually pay in advance... but, if it happens, the planned date should over ride the due date... since it was a manually entered number, and not a function of the invoice date plus the terms.

Got that resolved.

Last issue conceivable ( hate to say that, cause now there'll be others )

Is this possible -

No bill date,
no plan to pay date,
yet...
a payment it posted with a date.

I really think that if they post it, a planned to pay date should be posted along with it, but I'm not the one who has to use the thing, so lemme know!

I believe we've now covered - planned date before bill date, no planned date, no due date.