Being able to count networkdays by month in a range that covers two months!

Hi there

I'm trying to create a calculation of a date range... for example

So I have a networkdays formula counting the working days between the start date and end date. However, what I'm looking for is a formula that will count the network days for each month, for example above, June in a column, and the July dates in another column.

Any help would be greatly appreciated!

Many thanks

Jo

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!