working days between hire and term dates

[btardo01]

I have an employees start date in cell H11 and the term date in cell I11. In cells J6:U6, I have the months of 1/1/2019 - 12/1/2019. In cells J3:U3, I'm trying to calculate the number of working days that employee worked that month given their starting and term date. If the employee is still active, the term date column would be blank. The hire date could be prior to 1/1/2019 or anytime within the year. There could be a hire date and term date within the same year.

any ideas?
thanks

 

[steve the fish]

Test this:

=IF(MONTH(J6)>MONTH($I$11),0,NETWORKDAYS(MAX($H$11,J6),MIN(IF($I$11="",TODAY(),$I$11),EOMONTH(J6,0))))

 

[steve the fish]

Actually this:

=IF(MIN(IF($I$11="",99999,$I$11),EOMONTH(J6,0))>=MAX($H$11,J6),NETWORKDAYS(MAX($H$11,J6),MIN(IF($I$11="",99999,$I$11),EOMONTH(J6,0))),0)

 

[Tetra201]

A shorter one; returns zero if the hire date cell is blank:

=NETWORKDAYS(MAX(J6,$H$11),MIN(EOMONTH(J6,0),$I$11))*(IF($H$11="",99999,$H$11) < EDATE(J6,1))*(IF($I$11="",99999,$I$11)>=J6)

 

[btardo01]

thanks all for the responses.