Forum Discussion
NeilKloster
Jul 01, 2020Brass Contributor
Subtracting nights/weekends from workdays
Hello, I have a situation where I am looking for help and guidance as I'm still new to Excel and formulas. I have a spreadsheet where I am trying to track when a case was open from a...
NeilKloster
Jul 06, 2020Brass Contributor
Thank you so much !hynguyen
This helps - I might need to adjust 1-2 things, but this definitely gets me on the right track. Any thoughts on how to account for holidays at all?
Neil
hynguyen
Jul 08, 2020Iron Contributor
NeilKloster If you want to exclude also holidays, revise the Networkday.INTL formula in column Workday hours to incorporate the range of your holidays