Hi there,
We have invoices that we pay as per contractual terms. But if due date falls on a holiday, we pay the invoice 1 working day earlier. I'm not sure how to adjust this with a formula
Tabs:
Holiday Adjusted - Would like for this to pull in payment value like with the Pmt Date tab but adjusted for holidays, i.e., pay a working day early if falls on a Holiday.
Pmt Date - payments as per invoice due date, split by country and currency
Holiday - list of holidays per country
Thanks
Sketched a sample in dropbox
We have invoices that we pay as per contractual terms. But if due date falls on a holiday, we pay the invoice 1 working day earlier. I'm not sure how to adjust this with a formula
Tabs:
Holiday Adjusted - Would like for this to pull in payment value like with the Pmt Date tab but adjusted for holidays, i.e., pay a working day early if falls on a Holiday.
Pmt Date - payments as per invoice due date, split by country and currency
Holiday - list of holidays per country
Thanks
Sketched a sample in dropbox