Hello Mr. Excel Community - I'm trying to forecast payment date/amount for some payment terms that are more complicated than the usual net 30. Does anyone have any recommendations here for some formulas that are dynamic?
Here are some of the payment terms:
<colgroup><col></colgroup><tbody>
35%...