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 Formula Help
-
- NewLounger
- Posts: 2
- Joined: 11 Aug 2022, 17:43
NetWorkdays Formula Help
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: NetWorkdays Formula Help
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.
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.
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 2
- Joined: 11 Aug 2022, 17:43
Re: NetWorkdays Formula Help
You're a life saver! Thank you I would never have gotten that to work.
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: NetWorkdays Formula Help
You're welcome. Don't hesitate to ask more questions.
Best wishes,
Hans
Hans