need to compute networkdays but include individual's vacations, as well as federal holiday

[icestationzbra]

hi,

for computing availability of a team member during an Agile Sprint, i have this situation:

sprint1 starts 15-JUN-23, ends 28-JUN-23. 19th June is US Federal Holiday.

sprint2 starts 29-JUN-23, ends 12-JUL-23. 4th July is US Federal Holiday.

J Doe is on vacation between 25-JUN-23 and 4-JUL-23 (inclusive).
J Doe's availability during the sprint is 6 days for either sprint, i would like the formula to tell me.

as you can imagine, there are several team members, with different vacation schedules, and there are many more holidays during subsequent sprints (e.g., 4th of July for the next sprint). so a formula that would be dynamic enough to handle all that is desired.



thanks in advance.



posted need to compute networkdays but include individual's vacations, as well as federal holiday also

 

[icestationzbra]

hi awoohaw, i sincerely appreciate your taking the time to identify the issue and providing a more comprehensive solution.

i had posted this problem elsewhere also, and Haseeb A has provided a very nice solution on the thread, i thought you might be interested in checking it out:

need to compute networkdays but include individual's vacations, as well as federal holiday [SOLVED]

hi, for computing availability of a team member during an Agile Sprint, i have this situation: sprint starts 15-JUN-23, ends 28-JUN-23. 19th June is US Federal Holiday. J Doe is on vacation between 25-JUN-23 and 4-JUL-23 (inclusive). J Doe's availability during the sprint is 6 days...

tinyurl.com