NETWORKDAYS for specific months

[Gage]

Howdy,

I am trying to track how much of each months departmental holiday budget has been used.

However, I am struggling to get NETWORKDAYS to calculate the individual months in the header when someone has requested holiday spanning more than one month, like March to April. Kindly see example below- formula works fine but only for counting the total days, not working days.

Any help would be appreciated, significantly.

 

[Fluff]

you do realize that all the work here was mine...

What about post#3?

 

[Keebler]

Fluff, true!
if you want to be "specific" AND post #1 - lol

 

[Dave Patton]

You just provided an image. I cannot work with an image and it is unclear what is in some of the cells.

You can copy post # 3 to a clean sheet and review the formulas.
Click on the icon f(x) below the heading, then move to your sheet, select cell A1 and paste.