Hi Steve,
can you have a formula to count the days between the two dates, another to count the working days using netWorkDays and minus one from the other to get the weekend days?
And for calculating public holidays, look at this post: Bank Holiday calc with Calendar Days
Let me know if you need a hand.
Hugo