Good Day
I have a problem where I have a payment amount that needs to be paid over a number of days starting on a particular date. I also need to exclude weekends but then catch up the missing payments over the days following the weekend. i.e. In
my example I have a payment amount of 1,000 that needs to be paid over 5 days with the first day starting on Friday therefore Saturday and Sunday would be zero but need the formula to catch-up the missing days from Monday onwards.
I have attached a work as the problem statement if I didn't articulate the problem correctly
Thanks again
Bookmarks