Forum Discussion
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 Please check the attached workbook. I break the calculation into steps to make it easier to understand. The last column is the single formula combining all the steps in previous columns.
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
NeilKloster If you want to exclude also holidays, revise the Networkday.INTL formula in column Workday hours to incorporate the range of your holidays
