calculate dates based on company and active

[RSnap3232]

hello All,

I have the below that works out whether or not a company charges weekends/ bank holidays but I now need to modify it to also include a running count on days if the product is still being used ie =Today() if product is active (still only calculating whether they charge weekends or not) or use end date if product is Closed. Any idea?

 

[JamesCanale]

M2 shows the running total, but will stop growing after 12/31/21 (in this case) when the end date is passed.

MrExcelPlayground.xlsx
	K	L	M
1			Running
2	days:	261	33
3			Holidays
4	Start	1/1/2021	1/18/2021
5	End	12/31/2021	12/25/2021
6	Company	B company	7/31/2021
7			11/23/2021
8			7/4/2021
9
10	Company	Uses bank holiday
11	A company	TRUE
12	B company	FALSE
13	C Company	TRUE
Sheet10

Cell Formulas
Range	Formula
L2	L2	=IF(VLOOKUP(L6,K11:L13,2,FALSE),NETWORKDAYS(L4,L5,M4:M8),NETWORKDAYS(L4,L5))
M2	M2	=IF(VLOOKUP(L6,K11:L13,2,FALSE),NETWORKDAYS(L4,MIN(L5,TODAY()),M4:M8),NETWORKDAYS(L4,MIN(L5,TODAY())))

 

[RSnap3232]

M2 shows the running total, but will stop growing after 12/31/21 (in this case) when the end date is passed.

MrExcelPlayground.xlsx
	K	L	M
1			Running
2	days:	261	33
3			Holidays
4	Start	1/1/2021	1/18/2021
5	End	12/31/2021	12/25/2021
6	Company	B company	7/31/2021
7			11/23/2021
8			7/4/2021
9
10	Company	Uses bank holiday
11	A company	TRUE
12	B company	FALSE
13	C Company	TRUE
Sheet10

Cell Formulas
Range	Formula
L2	L2	=IF(VLOOKUP(L6,K11:L13,2,FALSE),NETWORKDAYS(L4,L5,M4:M8),NETWORKDAYS(L4,L5))
M2	M2	=IF(VLOOKUP(L6,K11:L13,2,FALSE),NETWORKDAYS(L4,MIN(L5,TODAY()),M4:M8),NETWORKDAYS(L4,MIN(L5,TODAY())))

thank you kindly sir that is brilliant