work days split between month/ week

[RSnap3232]

Hello All,

trying to calculate how long something is on hire for which is then split between month (Ideally looking for weeks but happy to do month if it can't be done) without including weekends. I have the below where it calculates between a start date and end date (If no end date it uses TODAY() as a running cost) but when I try to get the split it still includes the weekends and I have no idea how to change it to network days.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1
2
3
4
5						01/01/2021	01/02/2021	01/03/2021	01/04/2021	01/05/2021	01/06/2021	01/07/2021
6
7	01/05/2021		15							15
8	01/02/2021	12/05/2021	73				20	23	22	8
Main

Cell Formulas
Range	Formula
F7:L8	F7	=IF(OR($A7>EOMONTH(F$5,0),IF($B7="",TODAY(),$B7)<F$5),"",NETWORKDAYS(MAX($A7,F$5),MIN(IF($B7="",TODAY(),$B7),EOMONTH(F$5,0))))
C7:C8	C7	=NETWORKDAYS(A7,IF(B7="",TODAY(),B7))

 

[RSnap3232]

that is brilliant thank you.

 

[Fluff]

You're welcome & thanks for the feedback.