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 out of the possible 9 days for that 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.
i am drawing a blank. thanks for the assistance. make @daddylonglegs proud with a fabulous date / time formula.
Bookmarks