This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The attached workflow should solve your problem. Using a Generate Rows tool, you create each date inbetween your Pay and Due Date Values. You can then use the formula tool to assign weekday names, allowing you to Filter out Weekend Values.
You then use the Summarize Tool to get the counts for each of these fields and join to your original dataset.
It requires 2 different streams for when Due Date is past Pay Date and Vice Versa, when using the Generate Rows Tool.