Hi, I want to calcualte the penalty on itmes clients checked out and became overdue. Here is the penalty I would like to calculate.
If an item have been over due for 15 days the first 10 business days would be free. Any calendar days after that (in this case, 5 days, including weekends) would be penalized based on how many days that would be (in this case, 5 days). I was able to do the calendar and business days without problem. My problem is I do not know how to calculate the first 10 business days (excluded weekends) and then calculate the penalty with the calendar days after taht. For example, the due date is 11/1 and is 15 days past due. The client is only penalized for 3 days.
Thanks in advance for any help I can get.
If an item have been over due for 15 days the first 10 business days would be free. Any calendar days after that (in this case, 5 days, including weekends) would be penalized based on how many days that would be (in this case, 5 days). I was able to do the calendar and business days without problem. My problem is I do not know how to calculate the first 10 business days (excluded weekends) and then calculate the penalty with the calendar days after taht. For example, the due date is 11/1 and is 15 days past due. The client is only penalized for 3 days.
Thanks in advance for any help I can get.