Determine monthly impact of production from start and finish dates in VBA?

[stevearama]

Hi there. I have a range of factories that make product. Those factories will shutdown for maintenance for some period of time, and I wish to show the lost production by month.

I have created a spreadsheet with excel formulas, but it is slow for large datasets (say 50,000 rows with shutdowns over a 10 year period).

i thought it might be faster to use vba. Can anyone help me do this in VBA?

Attached is my sheet.


Excel 2016 (Windows) 32 bit

	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]H[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]I[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]J[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]K[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]L[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]M[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]N[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]O[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]P[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Q[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]R[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]S[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]T[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]U[/COLOR]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]1[/COLOR]​	Factory	Rate t/day	Start date	Finish Date	=EOMONTH(MIN(C2:C17),-1)+1​	=EDATE(E1,1)​	=EDATE(F1,1)​	=EDATE(G1,1)​	=EDATE(H1,1)​	=EDATE(I1,1)​	=EDATE(J1,1)​	=EDATE(K1,1)​	=EDATE(L1,1)​	=EDATE(M1,1)​	=EDATE(N1,1)​	=EDATE(O1,1)​	=EDATE(P1,1)​	=EDATE(Q1,1)​	=EDATE(R1,1)​	=EDATE(S1,1)​	=EDATE(T1,1)​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​	a	95​	7/01/2019​	3/02/2019​	=$B2*((MAX(EOMONTH(E$1,0)-$C2,0)-MAX(EOMONTH(E$1,-1)-$C2,0))-(MAX(EOMONTH(E$1,0)-$D2,0)-MAX(EOMONTH(E$1,-1)-$D2,0))+(EOMONTH(E$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(F$1,0)-$C2,0)-MAX(EOMONTH(F$1,-1)-$C2,0))-(MAX(EOMONTH(F$1,0)-$D2,0)-MAX(EOMONTH(F$1,-1)-$D2,0))+(EOMONTH(F$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(G$1,0)-$C2,0)-MAX(EOMONTH(G$1,-1)-$C2,0))-(MAX(EOMONTH(G$1,0)-$D2,0)-MAX(EOMONTH(G$1,-1)-$D2,0))+(EOMONTH(G$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(H$1,0)-$C2,0)-MAX(EOMONTH(H$1,-1)-$C2,0))-(MAX(EOMONTH(H$1,0)-$D2,0)-MAX(EOMONTH(H$1,-1)-$D2,0))+(EOMONTH(H$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(I$1,0)-$C2,0)-MAX(EOMONTH(I$1,-1)-$C2,0))-(MAX(EOMONTH(I$1,0)-$D2,0)-MAX(EOMONTH(I$1,-1)-$D2,0))+(EOMONTH(I$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(J$1,0)-$C2,0)-MAX(EOMONTH(J$1,-1)-$C2,0))-(MAX(EOMONTH(J$1,0)-$D2,0)-MAX(EOMONTH(J$1,-1)-$D2,0))+(EOMONTH(J$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(K$1,0)-$C2,0)-MAX(EOMONTH(K$1,-1)-$C2,0))-(MAX(EOMONTH(K$1,0)-$D2,0)-MAX(EOMONTH(K$1,-1)-$D2,0))+(EOMONTH(K$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(L$1,0)-$C2,0)-MAX(EOMONTH(L$1,-1)-$C2,0))-(MAX(EOMONTH(L$1,0)-$D2,0)-MAX(EOMONTH(L$1,-1)-$D2,0))+(EOMONTH(L$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(M$1,0)-$C2,0)-MAX(EOMONTH(M$1,-1)-$C2,0))-(MAX(EOMONTH(M$1,0)-$D2,0)-MAX(EOMONTH(M$1,-1)-$D2,0))+(EOMONTH(M$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(N$1,0)-$C2,0)-MAX(EOMONTH(N$1,-1)-$C2,0))-(MAX(EOMONTH(N$1,0)-$D2,0)-MAX(EOMONTH(N$1,-1)-$D2,0))+(EOMONTH(N$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(O$1,0)-$C2,0)-MAX(EOMONTH(O$1,-1)-$C2,0))-(MAX(EOMONTH(O$1,0)-$D2,0)-MAX(EOMONTH(O$1,-1)-$D2,0))+(EOMONTH(O$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(P$1,0)-$C2,0)-MAX(EOMONTH(P$1,-1)-$C2,0))-(MAX(EOMONTH(P$1,0)-$D2,0)-MAX(EOMONTH(P$1,-1)-$D2,0))+(EOMONTH(P$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(Q$1,0)-$C2,0)-MAX(EOMONTH(Q$1,-1)-$C2,0))-(MAX(EOMONTH(Q$1,0)-$D2,0)-MAX(EOMONTH(Q$1,-1)-$D2,0))+(EOMONTH(Q$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(R$1,0)-$C2,0)-MAX(EOMONTH(R$1,-1)-$C2,0))-(MAX(EOMONTH(R$1,0)-$D2,0)-MAX(EOMONTH(R$1,-1)-$D2,0))+(EOMONTH(R$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(S$1,0)-$C2,0)-MAX(EOMONTH(S$1,-1)-$C2,0))-(MAX(EOMONTH(S$1,0)-$D2,0)-MAX(EOMONTH(S$1,-1)-$D2,0))+(EOMONTH(S$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(T$1,0)-$C2,0)-MAX(EOMONTH(T$1,-1)-$C2,0))-(MAX(EOMONTH(T$1,0)-$D2,0)-MAX(EOMONTH(T$1,-1)-$D2,0))+(EOMONTH(T$1,0)=EOMONTH($C2,0)))​	=$B2*((MAX(EOMONTH(U$1,0)-$C2,0)-MAX(EOMONTH(U$1,-1)-$C2,0))-(MAX(EOMONTH(U$1,0)-$D2,0)-MAX(EOMONTH(U$1,-1)-$D2,0))+(EOMONTH(U$1,0)=EOMONTH($C2,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​	b	127​	1/02/2019​	28/02/2019​	=$B3*((MAX(EOMONTH(E$1,0)-$C3,0)-MAX(EOMONTH(E$1,-1)-$C3,0))-(MAX(EOMONTH(E$1,0)-$D3,0)-MAX(EOMONTH(E$1,-1)-$D3,0))+(EOMONTH(E$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(F$1,0)-$C3,0)-MAX(EOMONTH(F$1,-1)-$C3,0))-(MAX(EOMONTH(F$1,0)-$D3,0)-MAX(EOMONTH(F$1,-1)-$D3,0))+(EOMONTH(F$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(G$1,0)-$C3,0)-MAX(EOMONTH(G$1,-1)-$C3,0))-(MAX(EOMONTH(G$1,0)-$D3,0)-MAX(EOMONTH(G$1,-1)-$D3,0))+(EOMONTH(G$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(H$1,0)-$C3,0)-MAX(EOMONTH(H$1,-1)-$C3,0))-(MAX(EOMONTH(H$1,0)-$D3,0)-MAX(EOMONTH(H$1,-1)-$D3,0))+(EOMONTH(H$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(I$1,0)-$C3,0)-MAX(EOMONTH(I$1,-1)-$C3,0))-(MAX(EOMONTH(I$1,0)-$D3,0)-MAX(EOMONTH(I$1,-1)-$D3,0))+(EOMONTH(I$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(J$1,0)-$C3,0)-MAX(EOMONTH(J$1,-1)-$C3,0))-(MAX(EOMONTH(J$1,0)-$D3,0)-MAX(EOMONTH(J$1,-1)-$D3,0))+(EOMONTH(J$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(K$1,0)-$C3,0)-MAX(EOMONTH(K$1,-1)-$C3,0))-(MAX(EOMONTH(K$1,0)-$D3,0)-MAX(EOMONTH(K$1,-1)-$D3,0))+(EOMONTH(K$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(L$1,0)-$C3,0)-MAX(EOMONTH(L$1,-1)-$C3,0))-(MAX(EOMONTH(L$1,0)-$D3,0)-MAX(EOMONTH(L$1,-1)-$D3,0))+(EOMONTH(L$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(M$1,0)-$C3,0)-MAX(EOMONTH(M$1,-1)-$C3,0))-(MAX(EOMONTH(M$1,0)-$D3,0)-MAX(EOMONTH(M$1,-1)-$D3,0))+(EOMONTH(M$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(N$1,0)-$C3,0)-MAX(EOMONTH(N$1,-1)-$C3,0))-(MAX(EOMONTH(N$1,0)-$D3,0)-MAX(EOMONTH(N$1,-1)-$D3,0))+(EOMONTH(N$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(O$1,0)-$C3,0)-MAX(EOMONTH(O$1,-1)-$C3,0))-(MAX(EOMONTH(O$1,0)-$D3,0)-MAX(EOMONTH(O$1,-1)-$D3,0))+(EOMONTH(O$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(P$1,0)-$C3,0)-MAX(EOMONTH(P$1,-1)-$C3,0))-(MAX(EOMONTH(P$1,0)-$D3,0)-MAX(EOMONTH(P$1,-1)-$D3,0))+(EOMONTH(P$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(Q$1,0)-$C3,0)-MAX(EOMONTH(Q$1,-1)-$C3,0))-(MAX(EOMONTH(Q$1,0)-$D3,0)-MAX(EOMONTH(Q$1,-1)-$D3,0))+(EOMONTH(Q$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(R$1,0)-$C3,0)-MAX(EOMONTH(R$1,-1)-$C3,0))-(MAX(EOMONTH(R$1,0)-$D3,0)-MAX(EOMONTH(R$1,-1)-$D3,0))+(EOMONTH(R$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(S$1,0)-$C3,0)-MAX(EOMONTH(S$1,-1)-$C3,0))-(MAX(EOMONTH(S$1,0)-$D3,0)-MAX(EOMONTH(S$1,-1)-$D3,0))+(EOMONTH(S$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(T$1,0)-$C3,0)-MAX(EOMONTH(T$1,-1)-$C3,0))-(MAX(EOMONTH(T$1,0)-$D3,0)-MAX(EOMONTH(T$1,-1)-$D3,0))+(EOMONTH(T$1,0)=EOMONTH($C3,0)))​	=$B3*((MAX(EOMONTH(U$1,0)-$C3,0)-MAX(EOMONTH(U$1,-1)-$C3,0))-(MAX(EOMONTH(U$1,0)-$D3,0)-MAX(EOMONTH(U$1,-1)-$D3,0))+(EOMONTH(U$1,0)=EOMONTH($C3,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​	c	112​	24/02/2019​	27/03/2019​	=$B4*((MAX(EOMONTH(E$1,0)-$C4,0)-MAX(EOMONTH(E$1,-1)-$C4,0))-(MAX(EOMONTH(E$1,0)-$D4,0)-MAX(EOMONTH(E$1,-1)-$D4,0))+(EOMONTH(E$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(F$1,0)-$C4,0)-MAX(EOMONTH(F$1,-1)-$C4,0))-(MAX(EOMONTH(F$1,0)-$D4,0)-MAX(EOMONTH(F$1,-1)-$D4,0))+(EOMONTH(F$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(G$1,0)-$C4,0)-MAX(EOMONTH(G$1,-1)-$C4,0))-(MAX(EOMONTH(G$1,0)-$D4,0)-MAX(EOMONTH(G$1,-1)-$D4,0))+(EOMONTH(G$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(H$1,0)-$C4,0)-MAX(EOMONTH(H$1,-1)-$C4,0))-(MAX(EOMONTH(H$1,0)-$D4,0)-MAX(EOMONTH(H$1,-1)-$D4,0))+(EOMONTH(H$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(I$1,0)-$C4,0)-MAX(EOMONTH(I$1,-1)-$C4,0))-(MAX(EOMONTH(I$1,0)-$D4,0)-MAX(EOMONTH(I$1,-1)-$D4,0))+(EOMONTH(I$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(J$1,0)-$C4,0)-MAX(EOMONTH(J$1,-1)-$C4,0))-(MAX(EOMONTH(J$1,0)-$D4,0)-MAX(EOMONTH(J$1,-1)-$D4,0))+(EOMONTH(J$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(K$1,0)-$C4,0)-MAX(EOMONTH(K$1,-1)-$C4,0))-(MAX(EOMONTH(K$1,0)-$D4,0)-MAX(EOMONTH(K$1,-1)-$D4,0))+(EOMONTH(K$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(L$1,0)-$C4,0)-MAX(EOMONTH(L$1,-1)-$C4,0))-(MAX(EOMONTH(L$1,0)-$D4,0)-MAX(EOMONTH(L$1,-1)-$D4,0))+(EOMONTH(L$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(M$1,0)-$C4,0)-MAX(EOMONTH(M$1,-1)-$C4,0))-(MAX(EOMONTH(M$1,0)-$D4,0)-MAX(EOMONTH(M$1,-1)-$D4,0))+(EOMONTH(M$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(N$1,0)-$C4,0)-MAX(EOMONTH(N$1,-1)-$C4,0))-(MAX(EOMONTH(N$1,0)-$D4,0)-MAX(EOMONTH(N$1,-1)-$D4,0))+(EOMONTH(N$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(O$1,0)-$C4,0)-MAX(EOMONTH(O$1,-1)-$C4,0))-(MAX(EOMONTH(O$1,0)-$D4,0)-MAX(EOMONTH(O$1,-1)-$D4,0))+(EOMONTH(O$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(P$1,0)-$C4,0)-MAX(EOMONTH(P$1,-1)-$C4,0))-(MAX(EOMONTH(P$1,0)-$D4,0)-MAX(EOMONTH(P$1,-1)-$D4,0))+(EOMONTH(P$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(Q$1,0)-$C4,0)-MAX(EOMONTH(Q$1,-1)-$C4,0))-(MAX(EOMONTH(Q$1,0)-$D4,0)-MAX(EOMONTH(Q$1,-1)-$D4,0))+(EOMONTH(Q$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(R$1,0)-$C4,0)-MAX(EOMONTH(R$1,-1)-$C4,0))-(MAX(EOMONTH(R$1,0)-$D4,0)-MAX(EOMONTH(R$1,-1)-$D4,0))+(EOMONTH(R$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(S$1,0)-$C4,0)-MAX(EOMONTH(S$1,-1)-$C4,0))-(MAX(EOMONTH(S$1,0)-$D4,0)-MAX(EOMONTH(S$1,-1)-$D4,0))+(EOMONTH(S$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(T$1,0)-$C4,0)-MAX(EOMONTH(T$1,-1)-$C4,0))-(MAX(EOMONTH(T$1,0)-$D4,0)-MAX(EOMONTH(T$1,-1)-$D4,0))+(EOMONTH(T$1,0)=EOMONTH($C4,0)))​	=$B4*((MAX(EOMONTH(U$1,0)-$C4,0)-MAX(EOMONTH(U$1,-1)-$C4,0))-(MAX(EOMONTH(U$1,0)-$D4,0)-MAX(EOMONTH(U$1,-1)-$D4,0))+(EOMONTH(U$1,0)=EOMONTH($C4,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​	d	184​	1/04/2019​	4/05/2019​	=$B5*((MAX(EOMONTH(E$1,0)-$C5,0)-MAX(EOMONTH(E$1,-1)-$C5,0))-(MAX(EOMONTH(E$1,0)-$D5,0)-MAX(EOMONTH(E$1,-1)-$D5,0))+(EOMONTH(E$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(F$1,0)-$C5,0)-MAX(EOMONTH(F$1,-1)-$C5,0))-(MAX(EOMONTH(F$1,0)-$D5,0)-MAX(EOMONTH(F$1,-1)-$D5,0))+(EOMONTH(F$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(G$1,0)-$C5,0)-MAX(EOMONTH(G$1,-1)-$C5,0))-(MAX(EOMONTH(G$1,0)-$D5,0)-MAX(EOMONTH(G$1,-1)-$D5,0))+(EOMONTH(G$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(H$1,0)-$C5,0)-MAX(EOMONTH(H$1,-1)-$C5,0))-(MAX(EOMONTH(H$1,0)-$D5,0)-MAX(EOMONTH(H$1,-1)-$D5,0))+(EOMONTH(H$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(I$1,0)-$C5,0)-MAX(EOMONTH(I$1,-1)-$C5,0))-(MAX(EOMONTH(I$1,0)-$D5,0)-MAX(EOMONTH(I$1,-1)-$D5,0))+(EOMONTH(I$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(J$1,0)-$C5,0)-MAX(EOMONTH(J$1,-1)-$C5,0))-(MAX(EOMONTH(J$1,0)-$D5,0)-MAX(EOMONTH(J$1,-1)-$D5,0))+(EOMONTH(J$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(K$1,0)-$C5,0)-MAX(EOMONTH(K$1,-1)-$C5,0))-(MAX(EOMONTH(K$1,0)-$D5,0)-MAX(EOMONTH(K$1,-1)-$D5,0))+(EOMONTH(K$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(L$1,0)-$C5,0)-MAX(EOMONTH(L$1,-1)-$C5,0))-(MAX(EOMONTH(L$1,0)-$D5,0)-MAX(EOMONTH(L$1,-1)-$D5,0))+(EOMONTH(L$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(M$1,0)-$C5,0)-MAX(EOMONTH(M$1,-1)-$C5,0))-(MAX(EOMONTH(M$1,0)-$D5,0)-MAX(EOMONTH(M$1,-1)-$D5,0))+(EOMONTH(M$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(N$1,0)-$C5,0)-MAX(EOMONTH(N$1,-1)-$C5,0))-(MAX(EOMONTH(N$1,0)-$D5,0)-MAX(EOMONTH(N$1,-1)-$D5,0))+(EOMONTH(N$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(O$1,0)-$C5,0)-MAX(EOMONTH(O$1,-1)-$C5,0))-(MAX(EOMONTH(O$1,0)-$D5,0)-MAX(EOMONTH(O$1,-1)-$D5,0))+(EOMONTH(O$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(P$1,0)-$C5,0)-MAX(EOMONTH(P$1,-1)-$C5,0))-(MAX(EOMONTH(P$1,0)-$D5,0)-MAX(EOMONTH(P$1,-1)-$D5,0))+(EOMONTH(P$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(Q$1,0)-$C5,0)-MAX(EOMONTH(Q$1,-1)-$C5,0))-(MAX(EOMONTH(Q$1,0)-$D5,0)-MAX(EOMONTH(Q$1,-1)-$D5,0))+(EOMONTH(Q$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(R$1,0)-$C5,0)-MAX(EOMONTH(R$1,-1)-$C5,0))-(MAX(EOMONTH(R$1,0)-$D5,0)-MAX(EOMONTH(R$1,-1)-$D5,0))+(EOMONTH(R$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(S$1,0)-$C5,0)-MAX(EOMONTH(S$1,-1)-$C5,0))-(MAX(EOMONTH(S$1,0)-$D5,0)-MAX(EOMONTH(S$1,-1)-$D5,0))+(EOMONTH(S$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(T$1,0)-$C5,0)-MAX(EOMONTH(T$1,-1)-$C5,0))-(MAX(EOMONTH(T$1,0)-$D5,0)-MAX(EOMONTH(T$1,-1)-$D5,0))+(EOMONTH(T$1,0)=EOMONTH($C5,0)))​	=$B5*((MAX(EOMONTH(U$1,0)-$C5,0)-MAX(EOMONTH(U$1,-1)-$C5,0))-(MAX(EOMONTH(U$1,0)-$D5,0)-MAX(EOMONTH(U$1,-1)-$D5,0))+(EOMONTH(U$1,0)=EOMONTH($C5,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​	e	28​	8/05/2019​	2/06/2019​	=$B6*((MAX(EOMONTH(E$1,0)-$C6,0)-MAX(EOMONTH(E$1,-1)-$C6,0))-(MAX(EOMONTH(E$1,0)-$D6,0)-MAX(EOMONTH(E$1,-1)-$D6,0))+(EOMONTH(E$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(F$1,0)-$C6,0)-MAX(EOMONTH(F$1,-1)-$C6,0))-(MAX(EOMONTH(F$1,0)-$D6,0)-MAX(EOMONTH(F$1,-1)-$D6,0))+(EOMONTH(F$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(G$1,0)-$C6,0)-MAX(EOMONTH(G$1,-1)-$C6,0))-(MAX(EOMONTH(G$1,0)-$D6,0)-MAX(EOMONTH(G$1,-1)-$D6,0))+(EOMONTH(G$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(H$1,0)-$C6,0)-MAX(EOMONTH(H$1,-1)-$C6,0))-(MAX(EOMONTH(H$1,0)-$D6,0)-MAX(EOMONTH(H$1,-1)-$D6,0))+(EOMONTH(H$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(I$1,0)-$C6,0)-MAX(EOMONTH(I$1,-1)-$C6,0))-(MAX(EOMONTH(I$1,0)-$D6,0)-MAX(EOMONTH(I$1,-1)-$D6,0))+(EOMONTH(I$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(J$1,0)-$C6,0)-MAX(EOMONTH(J$1,-1)-$C6,0))-(MAX(EOMONTH(J$1,0)-$D6,0)-MAX(EOMONTH(J$1,-1)-$D6,0))+(EOMONTH(J$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(K$1,0)-$C6,0)-MAX(EOMONTH(K$1,-1)-$C6,0))-(MAX(EOMONTH(K$1,0)-$D6,0)-MAX(EOMONTH(K$1,-1)-$D6,0))+(EOMONTH(K$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(L$1,0)-$C6,0)-MAX(EOMONTH(L$1,-1)-$C6,0))-(MAX(EOMONTH(L$1,0)-$D6,0)-MAX(EOMONTH(L$1,-1)-$D6,0))+(EOMONTH(L$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(M$1,0)-$C6,0)-MAX(EOMONTH(M$1,-1)-$C6,0))-(MAX(EOMONTH(M$1,0)-$D6,0)-MAX(EOMONTH(M$1,-1)-$D6,0))+(EOMONTH(M$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(N$1,0)-$C6,0)-MAX(EOMONTH(N$1,-1)-$C6,0))-(MAX(EOMONTH(N$1,0)-$D6,0)-MAX(EOMONTH(N$1,-1)-$D6,0))+(EOMONTH(N$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(O$1,0)-$C6,0)-MAX(EOMONTH(O$1,-1)-$C6,0))-(MAX(EOMONTH(O$1,0)-$D6,0)-MAX(EOMONTH(O$1,-1)-$D6,0))+(EOMONTH(O$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(P$1,0)-$C6,0)-MAX(EOMONTH(P$1,-1)-$C6,0))-(MAX(EOMONTH(P$1,0)-$D6,0)-MAX(EOMONTH(P$1,-1)-$D6,0))+(EOMONTH(P$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(Q$1,0)-$C6,0)-MAX(EOMONTH(Q$1,-1)-$C6,0))-(MAX(EOMONTH(Q$1,0)-$D6,0)-MAX(EOMONTH(Q$1,-1)-$D6,0))+(EOMONTH(Q$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(R$1,0)-$C6,0)-MAX(EOMONTH(R$1,-1)-$C6,0))-(MAX(EOMONTH(R$1,0)-$D6,0)-MAX(EOMONTH(R$1,-1)-$D6,0))+(EOMONTH(R$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(S$1,0)-$C6,0)-MAX(EOMONTH(S$1,-1)-$C6,0))-(MAX(EOMONTH(S$1,0)-$D6,0)-MAX(EOMONTH(S$1,-1)-$D6,0))+(EOMONTH(S$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(T$1,0)-$C6,0)-MAX(EOMONTH(T$1,-1)-$C6,0))-(MAX(EOMONTH(T$1,0)-$D6,0)-MAX(EOMONTH(T$1,-1)-$D6,0))+(EOMONTH(T$1,0)=EOMONTH($C6,0)))​	=$B6*((MAX(EOMONTH(U$1,0)-$C6,0)-MAX(EOMONTH(U$1,-1)-$C6,0))-(MAX(EOMONTH(U$1,0)-$D6,0)-MAX(EOMONTH(U$1,-1)-$D6,0))+(EOMONTH(U$1,0)=EOMONTH($C6,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR]​	f	114​	16/06/2019​	22/07/2019​	=$B7*((MAX(EOMONTH(E$1,0)-$C7,0)-MAX(EOMONTH(E$1,-1)-$C7,0))-(MAX(EOMONTH(E$1,0)-$D7,0)-MAX(EOMONTH(E$1,-1)-$D7,0))+(EOMONTH(E$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(F$1,0)-$C7,0)-MAX(EOMONTH(F$1,-1)-$C7,0))-(MAX(EOMONTH(F$1,0)-$D7,0)-MAX(EOMONTH(F$1,-1)-$D7,0))+(EOMONTH(F$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(G$1,0)-$C7,0)-MAX(EOMONTH(G$1,-1)-$C7,0))-(MAX(EOMONTH(G$1,0)-$D7,0)-MAX(EOMONTH(G$1,-1)-$D7,0))+(EOMONTH(G$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(H$1,0)-$C7,0)-MAX(EOMONTH(H$1,-1)-$C7,0))-(MAX(EOMONTH(H$1,0)-$D7,0)-MAX(EOMONTH(H$1,-1)-$D7,0))+(EOMONTH(H$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(I$1,0)-$C7,0)-MAX(EOMONTH(I$1,-1)-$C7,0))-(MAX(EOMONTH(I$1,0)-$D7,0)-MAX(EOMONTH(I$1,-1)-$D7,0))+(EOMONTH(I$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(J$1,0)-$C7,0)-MAX(EOMONTH(J$1,-1)-$C7,0))-(MAX(EOMONTH(J$1,0)-$D7,0)-MAX(EOMONTH(J$1,-1)-$D7,0))+(EOMONTH(J$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(K$1,0)-$C7,0)-MAX(EOMONTH(K$1,-1)-$C7,0))-(MAX(EOMONTH(K$1,0)-$D7,0)-MAX(EOMONTH(K$1,-1)-$D7,0))+(EOMONTH(K$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(L$1,0)-$C7,0)-MAX(EOMONTH(L$1,-1)-$C7,0))-(MAX(EOMONTH(L$1,0)-$D7,0)-MAX(EOMONTH(L$1,-1)-$D7,0))+(EOMONTH(L$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(M$1,0)-$C7,0)-MAX(EOMONTH(M$1,-1)-$C7,0))-(MAX(EOMONTH(M$1,0)-$D7,0)-MAX(EOMONTH(M$1,-1)-$D7,0))+(EOMONTH(M$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(N$1,0)-$C7,0)-MAX(EOMONTH(N$1,-1)-$C7,0))-(MAX(EOMONTH(N$1,0)-$D7,0)-MAX(EOMONTH(N$1,-1)-$D7,0))+(EOMONTH(N$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(O$1,0)-$C7,0)-MAX(EOMONTH(O$1,-1)-$C7,0))-(MAX(EOMONTH(O$1,0)-$D7,0)-MAX(EOMONTH(O$1,-1)-$D7,0))+(EOMONTH(O$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(P$1,0)-$C7,0)-MAX(EOMONTH(P$1,-1)-$C7,0))-(MAX(EOMONTH(P$1,0)-$D7,0)-MAX(EOMONTH(P$1,-1)-$D7,0))+(EOMONTH(P$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(Q$1,0)-$C7,0)-MAX(EOMONTH(Q$1,-1)-$C7,0))-(MAX(EOMONTH(Q$1,0)-$D7,0)-MAX(EOMONTH(Q$1,-1)-$D7,0))+(EOMONTH(Q$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(R$1,0)-$C7,0)-MAX(EOMONTH(R$1,-1)-$C7,0))-(MAX(EOMONTH(R$1,0)-$D7,0)-MAX(EOMONTH(R$1,-1)-$D7,0))+(EOMONTH(R$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(S$1,0)-$C7,0)-MAX(EOMONTH(S$1,-1)-$C7,0))-(MAX(EOMONTH(S$1,0)-$D7,0)-MAX(EOMONTH(S$1,-1)-$D7,0))+(EOMONTH(S$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(T$1,0)-$C7,0)-MAX(EOMONTH(T$1,-1)-$C7,0))-(MAX(EOMONTH(T$1,0)-$D7,0)-MAX(EOMONTH(T$1,-1)-$D7,0))+(EOMONTH(T$1,0)=EOMONTH($C7,0)))​	=$B7*((MAX(EOMONTH(U$1,0)-$C7,0)-MAX(EOMONTH(U$1,-1)-$C7,0))-(MAX(EOMONTH(U$1,0)-$D7,0)-MAX(EOMONTH(U$1,-1)-$D7,0))+(EOMONTH(U$1,0)=EOMONTH($C7,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR]​	g	190​	22/07/2019​	21/08/2019​	=$B8*((MAX(EOMONTH(E$1,0)-$C8,0)-MAX(EOMONTH(E$1,-1)-$C8,0))-(MAX(EOMONTH(E$1,0)-$D8,0)-MAX(EOMONTH(E$1,-1)-$D8,0))+(EOMONTH(E$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(F$1,0)-$C8,0)-MAX(EOMONTH(F$1,-1)-$C8,0))-(MAX(EOMONTH(F$1,0)-$D8,0)-MAX(EOMONTH(F$1,-1)-$D8,0))+(EOMONTH(F$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(G$1,0)-$C8,0)-MAX(EOMONTH(G$1,-1)-$C8,0))-(MAX(EOMONTH(G$1,0)-$D8,0)-MAX(EOMONTH(G$1,-1)-$D8,0))+(EOMONTH(G$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(H$1,0)-$C8,0)-MAX(EOMONTH(H$1,-1)-$C8,0))-(MAX(EOMONTH(H$1,0)-$D8,0)-MAX(EOMONTH(H$1,-1)-$D8,0))+(EOMONTH(H$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(I$1,0)-$C8,0)-MAX(EOMONTH(I$1,-1)-$C8,0))-(MAX(EOMONTH(I$1,0)-$D8,0)-MAX(EOMONTH(I$1,-1)-$D8,0))+(EOMONTH(I$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(J$1,0)-$C8,0)-MAX(EOMONTH(J$1,-1)-$C8,0))-(MAX(EOMONTH(J$1,0)-$D8,0)-MAX(EOMONTH(J$1,-1)-$D8,0))+(EOMONTH(J$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(K$1,0)-$C8,0)-MAX(EOMONTH(K$1,-1)-$C8,0))-(MAX(EOMONTH(K$1,0)-$D8,0)-MAX(EOMONTH(K$1,-1)-$D8,0))+(EOMONTH(K$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(L$1,0)-$C8,0)-MAX(EOMONTH(L$1,-1)-$C8,0))-(MAX(EOMONTH(L$1,0)-$D8,0)-MAX(EOMONTH(L$1,-1)-$D8,0))+(EOMONTH(L$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(M$1,0)-$C8,0)-MAX(EOMONTH(M$1,-1)-$C8,0))-(MAX(EOMONTH(M$1,0)-$D8,0)-MAX(EOMONTH(M$1,-1)-$D8,0))+(EOMONTH(M$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(N$1,0)-$C8,0)-MAX(EOMONTH(N$1,-1)-$C8,0))-(MAX(EOMONTH(N$1,0)-$D8,0)-MAX(EOMONTH(N$1,-1)-$D8,0))+(EOMONTH(N$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(O$1,0)-$C8,0)-MAX(EOMONTH(O$1,-1)-$C8,0))-(MAX(EOMONTH(O$1,0)-$D8,0)-MAX(EOMONTH(O$1,-1)-$D8,0))+(EOMONTH(O$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(P$1,0)-$C8,0)-MAX(EOMONTH(P$1,-1)-$C8,0))-(MAX(EOMONTH(P$1,0)-$D8,0)-MAX(EOMONTH(P$1,-1)-$D8,0))+(EOMONTH(P$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(Q$1,0)-$C8,0)-MAX(EOMONTH(Q$1,-1)-$C8,0))-(MAX(EOMONTH(Q$1,0)-$D8,0)-MAX(EOMONTH(Q$1,-1)-$D8,0))+(EOMONTH(Q$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(R$1,0)-$C8,0)-MAX(EOMONTH(R$1,-1)-$C8,0))-(MAX(EOMONTH(R$1,0)-$D8,0)-MAX(EOMONTH(R$1,-1)-$D8,0))+(EOMONTH(R$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(S$1,0)-$C8,0)-MAX(EOMONTH(S$1,-1)-$C8,0))-(MAX(EOMONTH(S$1,0)-$D8,0)-MAX(EOMONTH(S$1,-1)-$D8,0))+(EOMONTH(S$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(T$1,0)-$C8,0)-MAX(EOMONTH(T$1,-1)-$C8,0))-(MAX(EOMONTH(T$1,0)-$D8,0)-MAX(EOMONTH(T$1,-1)-$D8,0))+(EOMONTH(T$1,0)=EOMONTH($C8,0)))​	=$B8*((MAX(EOMONTH(U$1,0)-$C8,0)-MAX(EOMONTH(U$1,-1)-$C8,0))-(MAX(EOMONTH(U$1,0)-$D8,0)-MAX(EOMONTH(U$1,-1)-$D8,0))+(EOMONTH(U$1,0)=EOMONTH($C8,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR]​	h	186​	13/08/2019​	12/09/2019​	=$B9*((MAX(EOMONTH(E$1,0)-$C9,0)-MAX(EOMONTH(E$1,-1)-$C9,0))-(MAX(EOMONTH(E$1,0)-$D9,0)-MAX(EOMONTH(E$1,-1)-$D9,0))+(EOMONTH(E$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(F$1,0)-$C9,0)-MAX(EOMONTH(F$1,-1)-$C9,0))-(MAX(EOMONTH(F$1,0)-$D9,0)-MAX(EOMONTH(F$1,-1)-$D9,0))+(EOMONTH(F$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(G$1,0)-$C9,0)-MAX(EOMONTH(G$1,-1)-$C9,0))-(MAX(EOMONTH(G$1,0)-$D9,0)-MAX(EOMONTH(G$1,-1)-$D9,0))+(EOMONTH(G$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(H$1,0)-$C9,0)-MAX(EOMONTH(H$1,-1)-$C9,0))-(MAX(EOMONTH(H$1,0)-$D9,0)-MAX(EOMONTH(H$1,-1)-$D9,0))+(EOMONTH(H$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(I$1,0)-$C9,0)-MAX(EOMONTH(I$1,-1)-$C9,0))-(MAX(EOMONTH(I$1,0)-$D9,0)-MAX(EOMONTH(I$1,-1)-$D9,0))+(EOMONTH(I$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(J$1,0)-$C9,0)-MAX(EOMONTH(J$1,-1)-$C9,0))-(MAX(EOMONTH(J$1,0)-$D9,0)-MAX(EOMONTH(J$1,-1)-$D9,0))+(EOMONTH(J$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(K$1,0)-$C9,0)-MAX(EOMONTH(K$1,-1)-$C9,0))-(MAX(EOMONTH(K$1,0)-$D9,0)-MAX(EOMONTH(K$1,-1)-$D9,0))+(EOMONTH(K$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(L$1,0)-$C9,0)-MAX(EOMONTH(L$1,-1)-$C9,0))-(MAX(EOMONTH(L$1,0)-$D9,0)-MAX(EOMONTH(L$1,-1)-$D9,0))+(EOMONTH(L$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(M$1,0)-$C9,0)-MAX(EOMONTH(M$1,-1)-$C9,0))-(MAX(EOMONTH(M$1,0)-$D9,0)-MAX(EOMONTH(M$1,-1)-$D9,0))+(EOMONTH(M$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(N$1,0)-$C9,0)-MAX(EOMONTH(N$1,-1)-$C9,0))-(MAX(EOMONTH(N$1,0)-$D9,0)-MAX(EOMONTH(N$1,-1)-$D9,0))+(EOMONTH(N$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(O$1,0)-$C9,0)-MAX(EOMONTH(O$1,-1)-$C9,0))-(MAX(EOMONTH(O$1,0)-$D9,0)-MAX(EOMONTH(O$1,-1)-$D9,0))+(EOMONTH(O$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(P$1,0)-$C9,0)-MAX(EOMONTH(P$1,-1)-$C9,0))-(MAX(EOMONTH(P$1,0)-$D9,0)-MAX(EOMONTH(P$1,-1)-$D9,0))+(EOMONTH(P$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(Q$1,0)-$C9,0)-MAX(EOMONTH(Q$1,-1)-$C9,0))-(MAX(EOMONTH(Q$1,0)-$D9,0)-MAX(EOMONTH(Q$1,-1)-$D9,0))+(EOMONTH(Q$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(R$1,0)-$C9,0)-MAX(EOMONTH(R$1,-1)-$C9,0))-(MAX(EOMONTH(R$1,0)-$D9,0)-MAX(EOMONTH(R$1,-1)-$D9,0))+(EOMONTH(R$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(S$1,0)-$C9,0)-MAX(EOMONTH(S$1,-1)-$C9,0))-(MAX(EOMONTH(S$1,0)-$D9,0)-MAX(EOMONTH(S$1,-1)-$D9,0))+(EOMONTH(S$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(T$1,0)-$C9,0)-MAX(EOMONTH(T$1,-1)-$C9,0))-(MAX(EOMONTH(T$1,0)-$D9,0)-MAX(EOMONTH(T$1,-1)-$D9,0))+(EOMONTH(T$1,0)=EOMONTH($C9,0)))​	=$B9*((MAX(EOMONTH(U$1,0)-$C9,0)-MAX(EOMONTH(U$1,-1)-$C9,0))-(MAX(EOMONTH(U$1,0)-$D9,0)-MAX(EOMONTH(U$1,-1)-$D9,0))+(EOMONTH(U$1,0)=EOMONTH($C9,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR]​	i	169​	13/09/2019​	9/10/2019​	=$B10*((MAX(EOMONTH(E$1,0)-$C10,0)-MAX(EOMONTH(E$1,-1)-$C10,0))-(MAX(EOMONTH(E$1,0)-$D10,0)-MAX(EOMONTH(E$1,-1)-$D10,0))+(EOMONTH(E$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(F$1,0)-$C10,0)-MAX(EOMONTH(F$1,-1)-$C10,0))-(MAX(EOMONTH(F$1,0)-$D10,0)-MAX(EOMONTH(F$1,-1)-$D10,0))+(EOMONTH(F$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(G$1,0)-$C10,0)-MAX(EOMONTH(G$1,-1)-$C10,0))-(MAX(EOMONTH(G$1,0)-$D10,0)-MAX(EOMONTH(G$1,-1)-$D10,0))+(EOMONTH(G$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(H$1,0)-$C10,0)-MAX(EOMONTH(H$1,-1)-$C10,0))-(MAX(EOMONTH(H$1,0)-$D10,0)-MAX(EOMONTH(H$1,-1)-$D10,0))+(EOMONTH(H$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(I$1,0)-$C10,0)-MAX(EOMONTH(I$1,-1)-$C10,0))-(MAX(EOMONTH(I$1,0)-$D10,0)-MAX(EOMONTH(I$1,-1)-$D10,0))+(EOMONTH(I$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(J$1,0)-$C10,0)-MAX(EOMONTH(J$1,-1)-$C10,0))-(MAX(EOMONTH(J$1,0)-$D10,0)-MAX(EOMONTH(J$1,-1)-$D10,0))+(EOMONTH(J$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(K$1,0)-$C10,0)-MAX(EOMONTH(K$1,-1)-$C10,0))-(MAX(EOMONTH(K$1,0)-$D10,0)-MAX(EOMONTH(K$1,-1)-$D10,0))+(EOMONTH(K$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(L$1,0)-$C10,0)-MAX(EOMONTH(L$1,-1)-$C10,0))-(MAX(EOMONTH(L$1,0)-$D10,0)-MAX(EOMONTH(L$1,-1)-$D10,0))+(EOMONTH(L$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(M$1,0)-$C10,0)-MAX(EOMONTH(M$1,-1)-$C10,0))-(MAX(EOMONTH(M$1,0)-$D10,0)-MAX(EOMONTH(M$1,-1)-$D10,0))+(EOMONTH(M$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(N$1,0)-$C10,0)-MAX(EOMONTH(N$1,-1)-$C10,0))-(MAX(EOMONTH(N$1,0)-$D10,0)-MAX(EOMONTH(N$1,-1)-$D10,0))+(EOMONTH(N$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(O$1,0)-$C10,0)-MAX(EOMONTH(O$1,-1)-$C10,0))-(MAX(EOMONTH(O$1,0)-$D10,0)-MAX(EOMONTH(O$1,-1)-$D10,0))+(EOMONTH(O$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(P$1,0)-$C10,0)-MAX(EOMONTH(P$1,-1)-$C10,0))-(MAX(EOMONTH(P$1,0)-$D10,0)-MAX(EOMONTH(P$1,-1)-$D10,0))+(EOMONTH(P$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(Q$1,0)-$C10,0)-MAX(EOMONTH(Q$1,-1)-$C10,0))-(MAX(EOMONTH(Q$1,0)-$D10,0)-MAX(EOMONTH(Q$1,-1)-$D10,0))+(EOMONTH(Q$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(R$1,0)-$C10,0)-MAX(EOMONTH(R$1,-1)-$C10,0))-(MAX(EOMONTH(R$1,0)-$D10,0)-MAX(EOMONTH(R$1,-1)-$D10,0))+(EOMONTH(R$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(S$1,0)-$C10,0)-MAX(EOMONTH(S$1,-1)-$C10,0))-(MAX(EOMONTH(S$1,0)-$D10,0)-MAX(EOMONTH(S$1,-1)-$D10,0))+(EOMONTH(S$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(T$1,0)-$C10,0)-MAX(EOMONTH(T$1,-1)-$C10,0))-(MAX(EOMONTH(T$1,0)-$D10,0)-MAX(EOMONTH(T$1,-1)-$D10,0))+(EOMONTH(T$1,0)=EOMONTH($C10,0)))​	=$B10*((MAX(EOMONTH(U$1,0)-$C10,0)-MAX(EOMONTH(U$1,-1)-$C10,0))-(MAX(EOMONTH(U$1,0)-$D10,0)-MAX(EOMONTH(U$1,-1)-$D10,0))+(EOMONTH(U$1,0)=EOMONTH($C10,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR]​	j	225​	18/10/2019​	12/11/2019​	=$B11*((MAX(EOMONTH(E$1,0)-$C11,0)-MAX(EOMONTH(E$1,-1)-$C11,0))-(MAX(EOMONTH(E$1,0)-$D11,0)-MAX(EOMONTH(E$1,-1)-$D11,0))+(EOMONTH(E$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(F$1,0)-$C11,0)-MAX(EOMONTH(F$1,-1)-$C11,0))-(MAX(EOMONTH(F$1,0)-$D11,0)-MAX(EOMONTH(F$1,-1)-$D11,0))+(EOMONTH(F$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(G$1,0)-$C11,0)-MAX(EOMONTH(G$1,-1)-$C11,0))-(MAX(EOMONTH(G$1,0)-$D11,0)-MAX(EOMONTH(G$1,-1)-$D11,0))+(EOMONTH(G$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(H$1,0)-$C11,0)-MAX(EOMONTH(H$1,-1)-$C11,0))-(MAX(EOMONTH(H$1,0)-$D11,0)-MAX(EOMONTH(H$1,-1)-$D11,0))+(EOMONTH(H$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(I$1,0)-$C11,0)-MAX(EOMONTH(I$1,-1)-$C11,0))-(MAX(EOMONTH(I$1,0)-$D11,0)-MAX(EOMONTH(I$1,-1)-$D11,0))+(EOMONTH(I$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(J$1,0)-$C11,0)-MAX(EOMONTH(J$1,-1)-$C11,0))-(MAX(EOMONTH(J$1,0)-$D11,0)-MAX(EOMONTH(J$1,-1)-$D11,0))+(EOMONTH(J$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(K$1,0)-$C11,0)-MAX(EOMONTH(K$1,-1)-$C11,0))-(MAX(EOMONTH(K$1,0)-$D11,0)-MAX(EOMONTH(K$1,-1)-$D11,0))+(EOMONTH(K$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(L$1,0)-$C11,0)-MAX(EOMONTH(L$1,-1)-$C11,0))-(MAX(EOMONTH(L$1,0)-$D11,0)-MAX(EOMONTH(L$1,-1)-$D11,0))+(EOMONTH(L$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(M$1,0)-$C11,0)-MAX(EOMONTH(M$1,-1)-$C11,0))-(MAX(EOMONTH(M$1,0)-$D11,0)-MAX(EOMONTH(M$1,-1)-$D11,0))+(EOMONTH(M$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(N$1,0)-$C11,0)-MAX(EOMONTH(N$1,-1)-$C11,0))-(MAX(EOMONTH(N$1,0)-$D11,0)-MAX(EOMONTH(N$1,-1)-$D11,0))+(EOMONTH(N$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(O$1,0)-$C11,0)-MAX(EOMONTH(O$1,-1)-$C11,0))-(MAX(EOMONTH(O$1,0)-$D11,0)-MAX(EOMONTH(O$1,-1)-$D11,0))+(EOMONTH(O$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(P$1,0)-$C11,0)-MAX(EOMONTH(P$1,-1)-$C11,0))-(MAX(EOMONTH(P$1,0)-$D11,0)-MAX(EOMONTH(P$1,-1)-$D11,0))+(EOMONTH(P$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(Q$1,0)-$C11,0)-MAX(EOMONTH(Q$1,-1)-$C11,0))-(MAX(EOMONTH(Q$1,0)-$D11,0)-MAX(EOMONTH(Q$1,-1)-$D11,0))+(EOMONTH(Q$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(R$1,0)-$C11,0)-MAX(EOMONTH(R$1,-1)-$C11,0))-(MAX(EOMONTH(R$1,0)-$D11,0)-MAX(EOMONTH(R$1,-1)-$D11,0))+(EOMONTH(R$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(S$1,0)-$C11,0)-MAX(EOMONTH(S$1,-1)-$C11,0))-(MAX(EOMONTH(S$1,0)-$D11,0)-MAX(EOMONTH(S$1,-1)-$D11,0))+(EOMONTH(S$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(T$1,0)-$C11,0)-MAX(EOMONTH(T$1,-1)-$C11,0))-(MAX(EOMONTH(T$1,0)-$D11,0)-MAX(EOMONTH(T$1,-1)-$D11,0))+(EOMONTH(T$1,0)=EOMONTH($C11,0)))​	=$B11*((MAX(EOMONTH(U$1,0)-$C11,0)-MAX(EOMONTH(U$1,-1)-$C11,0))-(MAX(EOMONTH(U$1,0)-$D11,0)-MAX(EOMONTH(U$1,-1)-$D11,0))+(EOMONTH(U$1,0)=EOMONTH($C11,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR]​	k	175​	21/11/2019​	18/12/2019​	=$B12*((MAX(EOMONTH(E$1,0)-$C12,0)-MAX(EOMONTH(E$1,-1)-$C12,0))-(MAX(EOMONTH(E$1,0)-$D12,0)-MAX(EOMONTH(E$1,-1)-$D12,0))+(EOMONTH(E$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(F$1,0)-$C12,0)-MAX(EOMONTH(F$1,-1)-$C12,0))-(MAX(EOMONTH(F$1,0)-$D12,0)-MAX(EOMONTH(F$1,-1)-$D12,0))+(EOMONTH(F$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(G$1,0)-$C12,0)-MAX(EOMONTH(G$1,-1)-$C12,0))-(MAX(EOMONTH(G$1,0)-$D12,0)-MAX(EOMONTH(G$1,-1)-$D12,0))+(EOMONTH(G$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(H$1,0)-$C12,0)-MAX(EOMONTH(H$1,-1)-$C12,0))-(MAX(EOMONTH(H$1,0)-$D12,0)-MAX(EOMONTH(H$1,-1)-$D12,0))+(EOMONTH(H$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(I$1,0)-$C12,0)-MAX(EOMONTH(I$1,-1)-$C12,0))-(MAX(EOMONTH(I$1,0)-$D12,0)-MAX(EOMONTH(I$1,-1)-$D12,0))+(EOMONTH(I$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(J$1,0)-$C12,0)-MAX(EOMONTH(J$1,-1)-$C12,0))-(MAX(EOMONTH(J$1,0)-$D12,0)-MAX(EOMONTH(J$1,-1)-$D12,0))+(EOMONTH(J$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(K$1,0)-$C12,0)-MAX(EOMONTH(K$1,-1)-$C12,0))-(MAX(EOMONTH(K$1,0)-$D12,0)-MAX(EOMONTH(K$1,-1)-$D12,0))+(EOMONTH(K$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(L$1,0)-$C12,0)-MAX(EOMONTH(L$1,-1)-$C12,0))-(MAX(EOMONTH(L$1,0)-$D12,0)-MAX(EOMONTH(L$1,-1)-$D12,0))+(EOMONTH(L$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(M$1,0)-$C12,0)-MAX(EOMONTH(M$1,-1)-$C12,0))-(MAX(EOMONTH(M$1,0)-$D12,0)-MAX(EOMONTH(M$1,-1)-$D12,0))+(EOMONTH(M$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(N$1,0)-$C12,0)-MAX(EOMONTH(N$1,-1)-$C12,0))-(MAX(EOMONTH(N$1,0)-$D12,0)-MAX(EOMONTH(N$1,-1)-$D12,0))+(EOMONTH(N$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(O$1,0)-$C12,0)-MAX(EOMONTH(O$1,-1)-$C12,0))-(MAX(EOMONTH(O$1,0)-$D12,0)-MAX(EOMONTH(O$1,-1)-$D12,0))+(EOMONTH(O$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(P$1,0)-$C12,0)-MAX(EOMONTH(P$1,-1)-$C12,0))-(MAX(EOMONTH(P$1,0)-$D12,0)-MAX(EOMONTH(P$1,-1)-$D12,0))+(EOMONTH(P$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(Q$1,0)-$C12,0)-MAX(EOMONTH(Q$1,-1)-$C12,0))-(MAX(EOMONTH(Q$1,0)-$D12,0)-MAX(EOMONTH(Q$1,-1)-$D12,0))+(EOMONTH(Q$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(R$1,0)-$C12,0)-MAX(EOMONTH(R$1,-1)-$C12,0))-(MAX(EOMONTH(R$1,0)-$D12,0)-MAX(EOMONTH(R$1,-1)-$D12,0))+(EOMONTH(R$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(S$1,0)-$C12,0)-MAX(EOMONTH(S$1,-1)-$C12,0))-(MAX(EOMONTH(S$1,0)-$D12,0)-MAX(EOMONTH(S$1,-1)-$D12,0))+(EOMONTH(S$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(T$1,0)-$C12,0)-MAX(EOMONTH(T$1,-1)-$C12,0))-(MAX(EOMONTH(T$1,0)-$D12,0)-MAX(EOMONTH(T$1,-1)-$D12,0))+(EOMONTH(T$1,0)=EOMONTH($C12,0)))​	=$B12*((MAX(EOMONTH(U$1,0)-$C12,0)-MAX(EOMONTH(U$1,-1)-$C12,0))-(MAX(EOMONTH(U$1,0)-$D12,0)-MAX(EOMONTH(U$1,-1)-$D12,0))+(EOMONTH(U$1,0)=EOMONTH($C12,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR]​	l	207​	19/12/2019​	8/01/2020​	=$B13*((MAX(EOMONTH(E$1,0)-$C13,0)-MAX(EOMONTH(E$1,-1)-$C13,0))-(MAX(EOMONTH(E$1,0)-$D13,0)-MAX(EOMONTH(E$1,-1)-$D13,0))+(EOMONTH(E$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(F$1,0)-$C13,0)-MAX(EOMONTH(F$1,-1)-$C13,0))-(MAX(EOMONTH(F$1,0)-$D13,0)-MAX(EOMONTH(F$1,-1)-$D13,0))+(EOMONTH(F$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(G$1,0)-$C13,0)-MAX(EOMONTH(G$1,-1)-$C13,0))-(MAX(EOMONTH(G$1,0)-$D13,0)-MAX(EOMONTH(G$1,-1)-$D13,0))+(EOMONTH(G$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(H$1,0)-$C13,0)-MAX(EOMONTH(H$1,-1)-$C13,0))-(MAX(EOMONTH(H$1,0)-$D13,0)-MAX(EOMONTH(H$1,-1)-$D13,0))+(EOMONTH(H$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(I$1,0)-$C13,0)-MAX(EOMONTH(I$1,-1)-$C13,0))-(MAX(EOMONTH(I$1,0)-$D13,0)-MAX(EOMONTH(I$1,-1)-$D13,0))+(EOMONTH(I$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(J$1,0)-$C13,0)-MAX(EOMONTH(J$1,-1)-$C13,0))-(MAX(EOMONTH(J$1,0)-$D13,0)-MAX(EOMONTH(J$1,-1)-$D13,0))+(EOMONTH(J$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(K$1,0)-$C13,0)-MAX(EOMONTH(K$1,-1)-$C13,0))-(MAX(EOMONTH(K$1,0)-$D13,0)-MAX(EOMONTH(K$1,-1)-$D13,0))+(EOMONTH(K$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(L$1,0)-$C13,0)-MAX(EOMONTH(L$1,-1)-$C13,0))-(MAX(EOMONTH(L$1,0)-$D13,0)-MAX(EOMONTH(L$1,-1)-$D13,0))+(EOMONTH(L$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(M$1,0)-$C13,0)-MAX(EOMONTH(M$1,-1)-$C13,0))-(MAX(EOMONTH(M$1,0)-$D13,0)-MAX(EOMONTH(M$1,-1)-$D13,0))+(EOMONTH(M$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(N$1,0)-$C13,0)-MAX(EOMONTH(N$1,-1)-$C13,0))-(MAX(EOMONTH(N$1,0)-$D13,0)-MAX(EOMONTH(N$1,-1)-$D13,0))+(EOMONTH(N$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(O$1,0)-$C13,0)-MAX(EOMONTH(O$1,-1)-$C13,0))-(MAX(EOMONTH(O$1,0)-$D13,0)-MAX(EOMONTH(O$1,-1)-$D13,0))+(EOMONTH(O$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(P$1,0)-$C13,0)-MAX(EOMONTH(P$1,-1)-$C13,0))-(MAX(EOMONTH(P$1,0)-$D13,0)-MAX(EOMONTH(P$1,-1)-$D13,0))+(EOMONTH(P$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(Q$1,0)-$C13,0)-MAX(EOMONTH(Q$1,-1)-$C13,0))-(MAX(EOMONTH(Q$1,0)-$D13,0)-MAX(EOMONTH(Q$1,-1)-$D13,0))+(EOMONTH(Q$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(R$1,0)-$C13,0)-MAX(EOMONTH(R$1,-1)-$C13,0))-(MAX(EOMONTH(R$1,0)-$D13,0)-MAX(EOMONTH(R$1,-1)-$D13,0))+(EOMONTH(R$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(S$1,0)-$C13,0)-MAX(EOMONTH(S$1,-1)-$C13,0))-(MAX(EOMONTH(S$1,0)-$D13,0)-MAX(EOMONTH(S$1,-1)-$D13,0))+(EOMONTH(S$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(T$1,0)-$C13,0)-MAX(EOMONTH(T$1,-1)-$C13,0))-(MAX(EOMONTH(T$1,0)-$D13,0)-MAX(EOMONTH(T$1,-1)-$D13,0))+(EOMONTH(T$1,0)=EOMONTH($C13,0)))​	=$B13*((MAX(EOMONTH(U$1,0)-$C13,0)-MAX(EOMONTH(U$1,-1)-$C13,0))-(MAX(EOMONTH(U$1,0)-$D13,0)-MAX(EOMONTH(U$1,-1)-$D13,0))+(EOMONTH(U$1,0)=EOMONTH($C13,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR]​	m	251​	14/01/2020​	9/02/2020​	=$B14*((MAX(EOMONTH(E$1,0)-$C14,0)-MAX(EOMONTH(E$1,-1)-$C14,0))-(MAX(EOMONTH(E$1,0)-$D14,0)-MAX(EOMONTH(E$1,-1)-$D14,0))+(EOMONTH(E$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(F$1,0)-$C14,0)-MAX(EOMONTH(F$1,-1)-$C14,0))-(MAX(EOMONTH(F$1,0)-$D14,0)-MAX(EOMONTH(F$1,-1)-$D14,0))+(EOMONTH(F$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(G$1,0)-$C14,0)-MAX(EOMONTH(G$1,-1)-$C14,0))-(MAX(EOMONTH(G$1,0)-$D14,0)-MAX(EOMONTH(G$1,-1)-$D14,0))+(EOMONTH(G$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(H$1,0)-$C14,0)-MAX(EOMONTH(H$1,-1)-$C14,0))-(MAX(EOMONTH(H$1,0)-$D14,0)-MAX(EOMONTH(H$1,-1)-$D14,0))+(EOMONTH(H$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(I$1,0)-$C14,0)-MAX(EOMONTH(I$1,-1)-$C14,0))-(MAX(EOMONTH(I$1,0)-$D14,0)-MAX(EOMONTH(I$1,-1)-$D14,0))+(EOMONTH(I$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(J$1,0)-$C14,0)-MAX(EOMONTH(J$1,-1)-$C14,0))-(MAX(EOMONTH(J$1,0)-$D14,0)-MAX(EOMONTH(J$1,-1)-$D14,0))+(EOMONTH(J$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(K$1,0)-$C14,0)-MAX(EOMONTH(K$1,-1)-$C14,0))-(MAX(EOMONTH(K$1,0)-$D14,0)-MAX(EOMONTH(K$1,-1)-$D14,0))+(EOMONTH(K$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(L$1,0)-$C14,0)-MAX(EOMONTH(L$1,-1)-$C14,0))-(MAX(EOMONTH(L$1,0)-$D14,0)-MAX(EOMONTH(L$1,-1)-$D14,0))+(EOMONTH(L$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(M$1,0)-$C14,0)-MAX(EOMONTH(M$1,-1)-$C14,0))-(MAX(EOMONTH(M$1,0)-$D14,0)-MAX(EOMONTH(M$1,-1)-$D14,0))+(EOMONTH(M$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(N$1,0)-$C14,0)-MAX(EOMONTH(N$1,-1)-$C14,0))-(MAX(EOMONTH(N$1,0)-$D14,0)-MAX(EOMONTH(N$1,-1)-$D14,0))+(EOMONTH(N$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(O$1,0)-$C14,0)-MAX(EOMONTH(O$1,-1)-$C14,0))-(MAX(EOMONTH(O$1,0)-$D14,0)-MAX(EOMONTH(O$1,-1)-$D14,0))+(EOMONTH(O$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(P$1,0)-$C14,0)-MAX(EOMONTH(P$1,-1)-$C14,0))-(MAX(EOMONTH(P$1,0)-$D14,0)-MAX(EOMONTH(P$1,-1)-$D14,0))+(EOMONTH(P$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(Q$1,0)-$C14,0)-MAX(EOMONTH(Q$1,-1)-$C14,0))-(MAX(EOMONTH(Q$1,0)-$D14,0)-MAX(EOMONTH(Q$1,-1)-$D14,0))+(EOMONTH(Q$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(R$1,0)-$C14,0)-MAX(EOMONTH(R$1,-1)-$C14,0))-(MAX(EOMONTH(R$1,0)-$D14,0)-MAX(EOMONTH(R$1,-1)-$D14,0))+(EOMONTH(R$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(S$1,0)-$C14,0)-MAX(EOMONTH(S$1,-1)-$C14,0))-(MAX(EOMONTH(S$1,0)-$D14,0)-MAX(EOMONTH(S$1,-1)-$D14,0))+(EOMONTH(S$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(T$1,0)-$C14,0)-MAX(EOMONTH(T$1,-1)-$C14,0))-(MAX(EOMONTH(T$1,0)-$D14,0)-MAX(EOMONTH(T$1,-1)-$D14,0))+(EOMONTH(T$1,0)=EOMONTH($C14,0)))​	=$B14*((MAX(EOMONTH(U$1,0)-$C14,0)-MAX(EOMONTH(U$1,-1)-$C14,0))-(MAX(EOMONTH(U$1,0)-$D14,0)-MAX(EOMONTH(U$1,-1)-$D14,0))+(EOMONTH(U$1,0)=EOMONTH($C14,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]15[/COLOR]​	n	91​	19/02/2020​	########​	=$B15*((MAX(EOMONTH(E$1,0)-$C15,0)-MAX(EOMONTH(E$1,-1)-$C15,0))-(MAX(EOMONTH(E$1,0)-$D15,0)-MAX(EOMONTH(E$1,-1)-$D15,0))+(EOMONTH(E$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(F$1,0)-$C15,0)-MAX(EOMONTH(F$1,-1)-$C15,0))-(MAX(EOMONTH(F$1,0)-$D15,0)-MAX(EOMONTH(F$1,-1)-$D15,0))+(EOMONTH(F$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(G$1,0)-$C15,0)-MAX(EOMONTH(G$1,-1)-$C15,0))-(MAX(EOMONTH(G$1,0)-$D15,0)-MAX(EOMONTH(G$1,-1)-$D15,0))+(EOMONTH(G$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(H$1,0)-$C15,0)-MAX(EOMONTH(H$1,-1)-$C15,0))-(MAX(EOMONTH(H$1,0)-$D15,0)-MAX(EOMONTH(H$1,-1)-$D15,0))+(EOMONTH(H$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(I$1,0)-$C15,0)-MAX(EOMONTH(I$1,-1)-$C15,0))-(MAX(EOMONTH(I$1,0)-$D15,0)-MAX(EOMONTH(I$1,-1)-$D15,0))+(EOMONTH(I$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(J$1,0)-$C15,0)-MAX(EOMONTH(J$1,-1)-$C15,0))-(MAX(EOMONTH(J$1,0)-$D15,0)-MAX(EOMONTH(J$1,-1)-$D15,0))+(EOMONTH(J$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(K$1,0)-$C15,0)-MAX(EOMONTH(K$1,-1)-$C15,0))-(MAX(EOMONTH(K$1,0)-$D15,0)-MAX(EOMONTH(K$1,-1)-$D15,0))+(EOMONTH(K$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(L$1,0)-$C15,0)-MAX(EOMONTH(L$1,-1)-$C15,0))-(MAX(EOMONTH(L$1,0)-$D15,0)-MAX(EOMONTH(L$1,-1)-$D15,0))+(EOMONTH(L$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(M$1,0)-$C15,0)-MAX(EOMONTH(M$1,-1)-$C15,0))-(MAX(EOMONTH(M$1,0)-$D15,0)-MAX(EOMONTH(M$1,-1)-$D15,0))+(EOMONTH(M$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(N$1,0)-$C15,0)-MAX(EOMONTH(N$1,-1)-$C15,0))-(MAX(EOMONTH(N$1,0)-$D15,0)-MAX(EOMONTH(N$1,-1)-$D15,0))+(EOMONTH(N$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(O$1,0)-$C15,0)-MAX(EOMONTH(O$1,-1)-$C15,0))-(MAX(EOMONTH(O$1,0)-$D15,0)-MAX(EOMONTH(O$1,-1)-$D15,0))+(EOMONTH(O$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(P$1,0)-$C15,0)-MAX(EOMONTH(P$1,-1)-$C15,0))-(MAX(EOMONTH(P$1,0)-$D15,0)-MAX(EOMONTH(P$1,-1)-$D15,0))+(EOMONTH(P$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(Q$1,0)-$C15,0)-MAX(EOMONTH(Q$1,-1)-$C15,0))-(MAX(EOMONTH(Q$1,0)-$D15,0)-MAX(EOMONTH(Q$1,-1)-$D15,0))+(EOMONTH(Q$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(R$1,0)-$C15,0)-MAX(EOMONTH(R$1,-1)-$C15,0))-(MAX(EOMONTH(R$1,0)-$D15,0)-MAX(EOMONTH(R$1,-1)-$D15,0))+(EOMONTH(R$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(S$1,0)-$C15,0)-MAX(EOMONTH(S$1,-1)-$C15,0))-(MAX(EOMONTH(S$1,0)-$D15,0)-MAX(EOMONTH(S$1,-1)-$D15,0))+(EOMONTH(S$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(T$1,0)-$C15,0)-MAX(EOMONTH(T$1,-1)-$C15,0))-(MAX(EOMONTH(T$1,0)-$D15,0)-MAX(EOMONTH(T$1,-1)-$D15,0))+(EOMONTH(T$1,0)=EOMONTH($C15,0)))​	=$B15*((MAX(EOMONTH(U$1,0)-$C15,0)-MAX(EOMONTH(U$1,-1)-$C15,0))-(MAX(EOMONTH(U$1,0)-$D15,0)-MAX(EOMONTH(U$1,-1)-$D15,0))+(EOMONTH(U$1,0)=EOMONTH($C15,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]16[/COLOR]​	o	105​	########​	########​	=$B16*((MAX(EOMONTH(E$1,0)-$C16,0)-MAX(EOMONTH(E$1,-1)-$C16,0))-(MAX(EOMONTH(E$1,0)-$D16,0)-MAX(EOMONTH(E$1,-1)-$D16,0))+(EOMONTH(E$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(F$1,0)-$C16,0)-MAX(EOMONTH(F$1,-1)-$C16,0))-(MAX(EOMONTH(F$1,0)-$D16,0)-MAX(EOMONTH(F$1,-1)-$D16,0))+(EOMONTH(F$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(G$1,0)-$C16,0)-MAX(EOMONTH(G$1,-1)-$C16,0))-(MAX(EOMONTH(G$1,0)-$D16,0)-MAX(EOMONTH(G$1,-1)-$D16,0))+(EOMONTH(G$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(H$1,0)-$C16,0)-MAX(EOMONTH(H$1,-1)-$C16,0))-(MAX(EOMONTH(H$1,0)-$D16,0)-MAX(EOMONTH(H$1,-1)-$D16,0))+(EOMONTH(H$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(I$1,0)-$C16,0)-MAX(EOMONTH(I$1,-1)-$C16,0))-(MAX(EOMONTH(I$1,0)-$D16,0)-MAX(EOMONTH(I$1,-1)-$D16,0))+(EOMONTH(I$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(J$1,0)-$C16,0)-MAX(EOMONTH(J$1,-1)-$C16,0))-(MAX(EOMONTH(J$1,0)-$D16,0)-MAX(EOMONTH(J$1,-1)-$D16,0))+(EOMONTH(J$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(K$1,0)-$C16,0)-MAX(EOMONTH(K$1,-1)-$C16,0))-(MAX(EOMONTH(K$1,0)-$D16,0)-MAX(EOMONTH(K$1,-1)-$D16,0))+(EOMONTH(K$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(L$1,0)-$C16,0)-MAX(EOMONTH(L$1,-1)-$C16,0))-(MAX(EOMONTH(L$1,0)-$D16,0)-MAX(EOMONTH(L$1,-1)-$D16,0))+(EOMONTH(L$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(M$1,0)-$C16,0)-MAX(EOMONTH(M$1,-1)-$C16,0))-(MAX(EOMONTH(M$1,0)-$D16,0)-MAX(EOMONTH(M$1,-1)-$D16,0))+(EOMONTH(M$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(N$1,0)-$C16,0)-MAX(EOMONTH(N$1,-1)-$C16,0))-(MAX(EOMONTH(N$1,0)-$D16,0)-MAX(EOMONTH(N$1,-1)-$D16,0))+(EOMONTH(N$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(O$1,0)-$C16,0)-MAX(EOMONTH(O$1,-1)-$C16,0))-(MAX(EOMONTH(O$1,0)-$D16,0)-MAX(EOMONTH(O$1,-1)-$D16,0))+(EOMONTH(O$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(P$1,0)-$C16,0)-MAX(EOMONTH(P$1,-1)-$C16,0))-(MAX(EOMONTH(P$1,0)-$D16,0)-MAX(EOMONTH(P$1,-1)-$D16,0))+(EOMONTH(P$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(Q$1,0)-$C16,0)-MAX(EOMONTH(Q$1,-1)-$C16,0))-(MAX(EOMONTH(Q$1,0)-$D16,0)-MAX(EOMONTH(Q$1,-1)-$D16,0))+(EOMONTH(Q$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(R$1,0)-$C16,0)-MAX(EOMONTH(R$1,-1)-$C16,0))-(MAX(EOMONTH(R$1,0)-$D16,0)-MAX(EOMONTH(R$1,-1)-$D16,0))+(EOMONTH(R$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(S$1,0)-$C16,0)-MAX(EOMONTH(S$1,-1)-$C16,0))-(MAX(EOMONTH(S$1,0)-$D16,0)-MAX(EOMONTH(S$1,-1)-$D16,0))+(EOMONTH(S$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(T$1,0)-$C16,0)-MAX(EOMONTH(T$1,-1)-$C16,0))-(MAX(EOMONTH(T$1,0)-$D16,0)-MAX(EOMONTH(T$1,-1)-$D16,0))+(EOMONTH(T$1,0)=EOMONTH($C16,0)))​	=$B16*((MAX(EOMONTH(U$1,0)-$C16,0)-MAX(EOMONTH(U$1,-1)-$C16,0))-(MAX(EOMONTH(U$1,0)-$D16,0)-MAX(EOMONTH(U$1,-1)-$D16,0))+(EOMONTH(U$1,0)=EOMONTH($C16,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]17[/COLOR]​	p	74​	15/04/2020​	16/05/2020​	=$B17*((MAX(EOMONTH(E$1,0)-$C17,0)-MAX(EOMONTH(E$1,-1)-$C17,0))-(MAX(EOMONTH(E$1,0)-$D17,0)-MAX(EOMONTH(E$1,-1)-$D17,0))+(EOMONTH(E$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(F$1,0)-$C17,0)-MAX(EOMONTH(F$1,-1)-$C17,0))-(MAX(EOMONTH(F$1,0)-$D17,0)-MAX(EOMONTH(F$1,-1)-$D17,0))+(EOMONTH(F$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(G$1,0)-$C17,0)-MAX(EOMONTH(G$1,-1)-$C17,0))-(MAX(EOMONTH(G$1,0)-$D17,0)-MAX(EOMONTH(G$1,-1)-$D17,0))+(EOMONTH(G$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(H$1,0)-$C17,0)-MAX(EOMONTH(H$1,-1)-$C17,0))-(MAX(EOMONTH(H$1,0)-$D17,0)-MAX(EOMONTH(H$1,-1)-$D17,0))+(EOMONTH(H$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(I$1,0)-$C17,0)-MAX(EOMONTH(I$1,-1)-$C17,0))-(MAX(EOMONTH(I$1,0)-$D17,0)-MAX(EOMONTH(I$1,-1)-$D17,0))+(EOMONTH(I$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(J$1,0)-$C17,0)-MAX(EOMONTH(J$1,-1)-$C17,0))-(MAX(EOMONTH(J$1,0)-$D17,0)-MAX(EOMONTH(J$1,-1)-$D17,0))+(EOMONTH(J$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(K$1,0)-$C17,0)-MAX(EOMONTH(K$1,-1)-$C17,0))-(MAX(EOMONTH(K$1,0)-$D17,0)-MAX(EOMONTH(K$1,-1)-$D17,0))+(EOMONTH(K$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(L$1,0)-$C17,0)-MAX(EOMONTH(L$1,-1)-$C17,0))-(MAX(EOMONTH(L$1,0)-$D17,0)-MAX(EOMONTH(L$1,-1)-$D17,0))+(EOMONTH(L$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(M$1,0)-$C17,0)-MAX(EOMONTH(M$1,-1)-$C17,0))-(MAX(EOMONTH(M$1,0)-$D17,0)-MAX(EOMONTH(M$1,-1)-$D17,0))+(EOMONTH(M$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(N$1,0)-$C17,0)-MAX(EOMONTH(N$1,-1)-$C17,0))-(MAX(EOMONTH(N$1,0)-$D17,0)-MAX(EOMONTH(N$1,-1)-$D17,0))+(EOMONTH(N$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(O$1,0)-$C17,0)-MAX(EOMONTH(O$1,-1)-$C17,0))-(MAX(EOMONTH(O$1,0)-$D17,0)-MAX(EOMONTH(O$1,-1)-$D17,0))+(EOMONTH(O$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(P$1,0)-$C17,0)-MAX(EOMONTH(P$1,-1)-$C17,0))-(MAX(EOMONTH(P$1,0)-$D17,0)-MAX(EOMONTH(P$1,-1)-$D17,0))+(EOMONTH(P$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(Q$1,0)-$C17,0)-MAX(EOMONTH(Q$1,-1)-$C17,0))-(MAX(EOMONTH(Q$1,0)-$D17,0)-MAX(EOMONTH(Q$1,-1)-$D17,0))+(EOMONTH(Q$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(R$1,0)-$C17,0)-MAX(EOMONTH(R$1,-1)-$C17,0))-(MAX(EOMONTH(R$1,0)-$D17,0)-MAX(EOMONTH(R$1,-1)-$D17,0))+(EOMONTH(R$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(S$1,0)-$C17,0)-MAX(EOMONTH(S$1,-1)-$C17,0))-(MAX(EOMONTH(S$1,0)-$D17,0)-MAX(EOMONTH(S$1,-1)-$D17,0))+(EOMONTH(S$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(T$1,0)-$C17,0)-MAX(EOMONTH(T$1,-1)-$C17,0))-(MAX(EOMONTH(T$1,0)-$D17,0)-MAX(EOMONTH(T$1,-1)-$D17,0))+(EOMONTH(T$1,0)=EOMONTH($C17,0)))​	=$B17*((MAX(EOMONTH(U$1,0)-$C17,0)-MAX(EOMONTH(U$1,-1)-$C17,0))-(MAX(EOMONTH(U$1,0)-$D17,0)-MAX(EOMONTH(U$1,-1)-$D17,0))+(EOMONTH(U$1,0)=EOMONTH($C17,0)))​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]18[/COLOR]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]19[/COLOR]​	TOTAL				=SUM(E2:E17)​	=SUM(F2:F17)​	=SUM(G2:G17)​	=SUM(H2:H17)​	=SUM(I2:I17)​	=SUM(J2:J17)​	=SUM(K2:K17)​	=SUM(L2:L17)​	=SUM(M2:M17)​	=SUM(N2:N17)​	=SUM(O2:O17)​	=SUM(P2:P17)​	=SUM(Q2:Q17)​	=SUM(R2:R17)​	=SUM(S2:S17)​	=SUM(T2:T17)​	=SUM(U2:U17)​

<tbody>
</tbody>

Sheet: Model

<tbody>
</tbody>

 

[stevearama]

hmm, perhaps the formulas aren't helpful. here's the values. I wish I could just send you the sheet

Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​	L​	M​	N​	O​	P​	Q​	R​	S​	T​	U​
1​	Factory	Rate t/day	Start date	Finish Date	1/01/2019​	1/02/2019​	1/03/2019​	1/04/2019​	1/05/2019​	1/06/2019​	1/07/2019​	1/08/2019​	1/09/2019​	1/10/2019​	1/11/2019​	1/12/2019​	1/01/2020​	1/02/2020​	1/03/2020​	1/04/2020​	1/05/2020​
2​	a	95​	7/01/2019​	3/02/2019​	2375​	285​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​
3​	b	127​	1/02/2019​	28/02/2019​	0​	3556​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​
4​	c	112​	24/02/2019​	27/03/2019​	0​	560​	3024​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​
5​	d	184​	1/04/2019​	4/05/2019​	0​	0​	0​	5520​	736​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​
6​	e	28​	8/05/2019​	2/06/2019​	0​	0​	0​	0​	672​	56​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​
7​	f	114​	16/06/2019​	22/07/2019​	0​	0​	0​	0​	0​	1710​	2508​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​
8​	g	190​	22/07/2019​	21/08/2019​	0​	0​	0​	0​	0​	0​	1900​	3990​	0​	0​	0​	0​	0​	0​	0​	0​	0​
9​	h	186​	13/08/2019​	12/09/2019​	0​	0​	0​	0​	0​	0​	0​	3534​	2232​	0​	0​	0​	0​	0​	0​	0​	0​
10​	i	169​	13/09/2019​	9/10/2019​	0​	0​	0​	0​	0​	0​	0​	0​	3042​	1521​	0​	0​	0​	0​	0​	0​	0​
11​	j	225​	18/10/2019​	12/11/2019​	0​	0​	0​	0​	0​	0​	0​	0​	0​	3150​	2700​	0​	0​	0​	0​	0​	0​
12​	k	175​	21/11/2019​	18/12/2019​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	1750​	3150​	0​	0​	0​	0​	0​
13​	l	207​	19/12/2019​	8/01/2020​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	2691​	1656​	0​	0​	0​	0​
14​	m	251​	14/01/2020​	9/02/2020​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	4518​	2259​	0​	0​	0​
15​	n	91​	19/02/2020​	########​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	1001​	2730​	0​	0​
16​	o	105​	########​	########​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	1260​	2625​	0​
17​	p	74​	15/04/2020​	16/05/2020​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	0​	1184​	1184​
18​
19​	TOTAL				2375​	4401​	3024​	5520​	1408​	1766​	4408​	7524​	5274​	4671​	4450​	5841​	6174​	3260​	3990​	3809​	1184​

Sheet: Model

 

[NoSparks]

I wish I could just send you the sheet

You can't post files on this forum.
Use a file sharing site such as box.com or Dropbox where you upload your file then post the share link back here on the forum.

 

[stevearama]

Hello, I was able to write the macro, which works much faster but is still quite slow. I think it would be better to load the elements from the RC calc into memory as variables.
So, for example RC2 is the daily rate. The macro is getting this from the spreadsheet each iteration of the loop, perhasp it's faster to store these in variables, as well as the start and stop dates.. and the month to be assessed?

I don't know how to do that, any tips would be really helpful. Thanks.

Sub Macro4()
'
'
'
    
    Dim rng As Range
    Set rng = Range("E2: U17")
    
    Application.ScreenUpdating = False
    Application.Calculation = xlManual
    Application.EnableEvents = False
    
    For Each cell In rng
    cell.FormulaR1C1 = _
        "=RC2*((MAX(EOMONTH(R1C,0)-RC3,0)-MAX(EOMONTH(R1C,-1)-RC3,0))-(MAX(EOMONTH(R1C,0)-RC4,0)-MAX(EOMONTH(R1C,-1)-RC4,0))+(EOMONTH(R1C,0)=EOMONTH(RC3,0)))"
    cell.Formula = cell.Value
    Next cell


    Application.Calculation = xlAutomatic
    Application.ScreenUpdating = False
    Application.EnableEvents = True


 


End Sub

 

[stevearama]

You can't post files on this forum.
Use a file sharing site such as box.com or Dropbox where you upload your file then post the share link back here on the forum.

good idea.
https://www.dropbox.com/sh/49z1xsvt8p7a6u2/AABGqWFKZZD3YolnAp8bFsfea?dl=0