NetWorkdays Formula Help

[jclutie79]

I made a basic chart to try and figure this out and make it easier to show. I'm trying to figure out the way to write the formula into G2 to figure out the number of net workdays the person entered into F2 worked based on the date range entered in B2 (starting), and D2 (ending date).

Image Of the Chart

Networkdays_Image.png

[HansV]

Welcome to Eileen's Lonuge!

Do you have Microsoft 365 or Office 2021? If so, you can use

=COUNT(UNIQUE(IF((B6:B1000>=B2)*(B6:B1000<=D2)*(D6:D1000=F2),B6:B1000)))

If you have an older version, you need a more complicated formula. Let me know.

[jclutie79]

You're a life saver! Thank you I would never have gotten that to work.

[HansV]

You're welcome. Don't hesitate to ask more questions.