Formula For Counting Vacation Days

[Justinian]

I have a vacation calendar to create for 2020 and I use NETWORKDAYS to give me number of days that a person needs for vacation. For example, NETWORKDAYS formula applied to a vacation from 9/2-9/6/19 yields 5, which is correct. My problem is that some employees work on the weekends, so applying NETWORKDAYS to a vacation from 9/3-9/7/19 yields 4, which is incorrect because it is excluding that Saturday.

What formula can I use so that no matter what days of the week an employee is out on vacation, I will always get a correct count of the number of days?

 

[Joe4]

To be sure, it is more work "up-front", but it is doable, and if you have accounted for all scenarios, you can come up with a function that may save you time down the road.
The trick is that you need to really account for all/any scenarios in designing any sort of automated solution (as any solution that doesn't work in all cases is probably going to cause you more problems than it solves).

 

[Justinian]

I hear ya. There are too many uncommon vacation requests here plus we have a lot of employees who work odd schedules (e.g., Sunday through Thursday, Tuesday through Saturday, or Friday through Tuesday). Since this vacation calendar is only done once a year, I think it is far easier to manually count the requested days and enter into Excel rather than wanting a formula to work it out for me.