I am trying to create a function in VBA that calculates various due dates of invoices for different payment terms.
I am trying to figure out how to program some of the more complicated terms.
For example one company pays us on the 10th and the 25th of the month.
If the invoice is dated after the 25th but before the 10th of the next month then they will pay on the 25th of the next month
If the invoice is dated after the 10th but on or before the 25th then they will pay on the 10th of the next month.
I can't figure out how to code something like that.
THanks
Bookmarks