Number of working days per month between 2 Dates

[CurrentHamster]

Good Afternoon,

I'm trying to find a formula that will count the number of working days per month between two dates.

I can do the number of working days per month between two dates (If "End Date is blank it calculates using the last day of the current month):
Formula in C2:
=IF($B2="",NETWORKDAYS($A2,EOMONTH(TODAY(),0)),NETWORKDAYS($A2,$B2))[TABLE="width: 50"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Start Date
[/TD]
[TD]End Date
[/TD]
[TD]Full Time Equivalent
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]03/12/2018
[/TD]
[TD]02/01/2019
[/TD]
[TD]23
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]05/12/2018
[/TD]
[TD]07/01/2019
[/TD]
[TD]24
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]29/11/2018
[/TD]
[TD][/TD]
[TD]197
[/TD]
[/TR]
</tbody>[/TABLE]

I can also do the number of days per month betwen two dates:
[TABLE="width: 300"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Start Date
[/TD]
[TD]End Date
[/TD]
[TD]Full Time Equivalent
[/TD]
[TD]Dec-18
[/TD]
[TD]Jan-18
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]03/12/2018
[/TD]
[TD]02/01/2019
[/TD]
[TD]23
[/TD]
[TD]29
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]05/12/2018
[/TD]
[TD]07/01/2019
[/TD]
[TD]24
[/TD]
[TD]27
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]29/11/2018
[/TD]
[TD][/TD]
[TD]197
[/TD]
[TD]31
[/TD]
[TD]31
[/TD]
[/TR]
</tbody>[/TABLE]
=MAX(0,MIN(IF($b2="",TODAY(),$b2),EOMONTH(DATEVALUE(D$1),0))-MAX($A2,DATEVALUE(D$1))+1)

But I can't seem to combine the two together so that e.g. E3 should be 5 because the Sat 4th and Sun 5th, I don't need to exclude Bank Holidays just weekends.

 

[Mentor82]

Hi,
Try maybe calculationg network days where end date id.your end.date in column B but start dste would be date=last day of the month in column A sothat in E3 would be =Networkdays(31/12/2018,07/01/2018)

 

[Mentor82]

Hi again,
I do not think the solution I recommended will work. In order to cslculate networkdays you need start and end dates. End date would be the one in column B but what should be your start date for row 2, 3 and 4 in your example?

 

[Tetra201]

... E3 should be 5 because the Sat 4th and Sun 5th, I don't need to exclude Bank Holidays just weekends.

Try in E3

=NETWORKDAYS(MAX($A3,EOMONTH(DATEVALUE(E$1),-1)+1),MIN(IF($B3="",TODAY(),$B3),EOMONTH(DATEVALUE(E$1),0)))

 

[CurrentHamster]

That works perfectly, thank you very much!