Return the NETWORKDAYS of 1 month of a 2-month duration
The goal is to count the number of days that an Employee is not assigned work within a given month (MONTH A, MONTH B, etc).
For example, a given month has 23 working days; I could use NETWORKDAYS of the duration to count the assigned days of that Task; say 19. To reach my goal, I would simply subract the NETWORKDAYS from the number of workdays within that month: 23-19=4 days.
But... if the duration spans across 2 months, how can I return the NETWORKDAYS of this duration for just MONTH A? In the above example, 6 days are in MONTH A, and 13 days are in MONTH B.
Comments
-
=NETWORKDAYS([start date]3, DATE(YEAR([start date]3), MONTH([start date]3) + 1, 1) - 1)
You really need to think about how the program works in order to do this one. When you subtract 1 from a date it goes 1 day before. so you pick the first day of the next month and subtract 1 and it will go to the last day of the current month. you can add in an if statement before the DATE to say if the end date is before the end of the month then to use that date as well if you like.
Keep in mind this will only work for projects less than 1 year unless you add in that criteria with your if statement
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!