Hello
We have contractual payment terms that we need to adhere to, i.e., pay on time but on two occasions we pay early:
if the payment due date falls on a weekend, it should get paid early on the Friday just gone.
Also if payment due date falls on a holiday, it gets paid early, on the previous working day (if holiday on a Monday and due date is on that Monday, it will get paid on the previous Friday. If due date is a Monday but the previous Friday is a holiday also, it will get paid on a Thursday)
Not sure how to do this, especially as if have different holiday dates in different countries?
Holidays tab has the list of holidays by country and date as shown in pic. The Payment Date tab is where I need to populate a entries in the Amended Pay Date column by adjusting the Pay Date with the holidays tab info for whichever country is in Col A
Thanks
We have contractual payment terms that we need to adhere to, i.e., pay on time but on two occasions we pay early:
if the payment due date falls on a weekend, it should get paid early on the Friday just gone.
Also if payment due date falls on a holiday, it gets paid early, on the previous working day (if holiday on a Monday and due date is on that Monday, it will get paid on the previous Friday. If due date is a Monday but the previous Friday is a holiday also, it will get paid on a Thursday)
Not sure how to do this, especially as if have different holiday dates in different countries?
Holidays tab has the list of holidays by country and date as shown in pic. The Payment Date tab is where I need to populate a entries in the Amended Pay Date column by adjusting the Pay Date with the holidays tab info for whichever country is in Col A
Thanks