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

S

stevearama

New Member
Joined
Aug 31, 2019
Messages
5
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
[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[TH][/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]H[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]I[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]J[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]K[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]L[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]M[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]N[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]O[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]P[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Q[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]R[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]S[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]T[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]U[/COLOR]​
[/TH]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]1[/COLOR]​
[/TD]
[TD]Factory[/TD]
[TD]Rate t/day[/TD]
[TD]Start date[/TD]
[TD]Finish Date[/TD]
[TD="bgcolor: #FFFF00"]
=EOMONTH(MIN(C2:C17),-1)+1​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(E1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(F1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(G1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(H1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(I1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(J1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(K1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(L1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(M1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(N1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(O1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(P1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(Q1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(R1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(S1,1)​
[/TD]
[TD="bgcolor: #FFFF00"]
=EDATE(T1,1)​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​
[/TD]
[TD]a[/TD]
[TD]
95​
[/TD]
[TD]
7/01/2019​
[/TD]
[TD]
3/02/2019​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​
[/TD]
[TD]b[/TD]
[TD]
127​
[/TD]
[TD]
1/02/2019​
[/TD]
[TD]
28/02/2019​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​
[/TD]
[TD]c[/TD]
[TD]
112​
[/TD]
[TD]
24/02/2019​
[/TD]
[TD]
27/03/2019​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​
[/TD]
[TD]d[/TD]
[TD]
184​
[/TD]
[TD]
1/04/2019​
[/TD]
[TD]
4/05/2019​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​
[/TD]
[TD]e[/TD]
[TD]
28​
[/TD]
[TD]
8/05/2019​
[/TD]
[TD]
2/06/2019​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR]​
[/TD]
[TD]f[/TD]
[TD]
114​
[/TD]
[TD]
16/06/2019​
[/TD]
[TD]
22/07/2019​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR]​
[/TD]
[TD]g[/TD]
[TD]
190​
[/TD]
[TD]
22/07/2019​
[/TD]
[TD]
21/08/2019​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR]​
[/TD]
[TD]h[/TD]
[TD]
186​
[/TD]
[TD]
13/08/2019​
[/TD]
[TD]
12/09/2019​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR]​
[/TD]
[TD]i[/TD]
[TD]
169​
[/TD]
[TD]
13/09/2019​
[/TD]
[TD]
9/10/2019​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR]​
[/TD]
[TD]j[/TD]
[TD]
225​
[/TD]
[TD]
18/10/2019​
[/TD]
[TD]
12/11/2019​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR]​
[/TD]
[TD]k[/TD]
[TD]
175​
[/TD]
[TD]
21/11/2019​
[/TD]
[TD]
18/12/2019​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR]​
[/TD]
[TD]l[/TD]
[TD]
207​
[/TD]
[TD]
19/12/2019​
[/TD]
[TD]
8/01/2020​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR]​
[/TD]
[TD]m[/TD]
[TD]
251​
[/TD]
[TD]
14/01/2020​
[/TD]
[TD]
9/02/2020​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]15[/COLOR]​
[/TD]
[TD]n[/TD]
[TD]
91​
[/TD]
[TD]
19/02/2020​
[/TD]
[TD]
########​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]16[/COLOR]​
[/TD]
[TD]o[/TD]
[TD]
105​
[/TD]
[TD]
########​
[/TD]
[TD]
########​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]17[/COLOR]​
[/TD]
[TD]p[/TD]
[TD]
74​
[/TD]
[TD]
15/04/2020​
[/TD]
[TD]
16/05/2020​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[TD="bgcolor: #FFFF00"]
=$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)))​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]18[/COLOR]​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]19[/COLOR]​
[/TD]
[TD]TOTAL[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
=SUM(E2:E17)​
[/TD]
[TD]
=SUM(F2:F17)​
[/TD]
[TD]
=SUM(G2:G17)​
[/TD]
[TD]
=SUM(H2:H17)​
[/TD]
[TD]
=SUM(I2:I17)​
[/TD]
[TD]
=SUM(J2:J17)​
[/TD]
[TD]
=SUM(K2:K17)​
[/TD]
[TD]
=SUM(L2:L17)​
[/TD]
[TD]
=SUM(M2:M17)​
[/TD]
[TD]
=SUM(N2:N17)​
[/TD]
[TD]
=SUM(O2:O17)​
[/TD]
[TD]
=SUM(P2:P17)​
[/TD]
[TD]
=SUM(Q2:Q17)​
[/TD]
[TD]
=SUM(R2:R17)​
[/TD]
[TD]
=SUM(S2:S17)​
[/TD]
[TD]
=SUM(T2:T17)​
[/TD]
[TD]
=SUM(U2:U17)​
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: Model[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Sort by date Sort by votes
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
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]
A​
[/th][th]
B​
[/th][th]
C​
[/th][th]
D​
[/th][th]
E​
[/th][th]
F​
[/th][th]
G​
[/th][th]
H​
[/th][th]
I​
[/th][th]
J​
[/th][th]
K​
[/th][th]
L​
[/th][th]
M​
[/th][th]
N​
[/th][th]
O​
[/th][th]
P​
[/th][th]
Q​
[/th][th]
R​
[/th][th]
S​
[/th][th]
T​
[/th][th]
U​
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
1​
[/td][td]Factory[/td][td]Rate t/day[/td][td]Start date[/td][td]Finish Date[/td][td=bgcolor:#FFFF00]
1/01/2019​
[/td][td=bgcolor:#FFFF00]
1/02/2019​
[/td][td=bgcolor:#FFFF00]
1/03/2019​
[/td][td=bgcolor:#FFFF00]
1/04/2019​
[/td][td=bgcolor:#FFFF00]
1/05/2019​
[/td][td=bgcolor:#FFFF00]
1/06/2019​
[/td][td=bgcolor:#FFFF00]
1/07/2019​
[/td][td=bgcolor:#FFFF00]
1/08/2019​
[/td][td=bgcolor:#FFFF00]
1/09/2019​
[/td][td=bgcolor:#FFFF00]
1/10/2019​
[/td][td=bgcolor:#FFFF00]
1/11/2019​
[/td][td=bgcolor:#FFFF00]
1/12/2019​
[/td][td=bgcolor:#FFFF00]
1/01/2020​
[/td][td=bgcolor:#FFFF00]
1/02/2020​
[/td][td=bgcolor:#FFFF00]
1/03/2020​
[/td][td=bgcolor:#FFFF00]
1/04/2020​
[/td][td=bgcolor:#FFFF00]
1/05/2020​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
2​
[/td][td]a[/td][td]
95​
[/td][td]
7/01/2019​
[/td][td]
3/02/2019​
[/td][td=bgcolor:#FFFF00]
2375​
[/td][td=bgcolor:#FFFF00]
285​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
3​
[/td][td]b[/td][td]
127​
[/td][td]
1/02/2019​
[/td][td]
28/02/2019​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
3556​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
4​
[/td][td]c[/td][td]
112​
[/td][td]
24/02/2019​
[/td][td]
27/03/2019​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
560​
[/td][td=bgcolor:#FFFF00]
3024​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
5​
[/td][td]d[/td][td]
184​
[/td][td]
1/04/2019​
[/td][td]
4/05/2019​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
5520​
[/td][td=bgcolor:#FFFF00]
736​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
6​
[/td][td]e[/td][td]
28​
[/td][td]
8/05/2019​
[/td][td]
2/06/2019​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
672​
[/td][td=bgcolor:#FFFF00]
56​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
7​
[/td][td]f[/td][td]
114​
[/td][td]
16/06/2019​
[/td][td]
22/07/2019​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
1710​
[/td][td=bgcolor:#FFFF00]
2508​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
8​
[/td][td]g[/td][td]
190​
[/td][td]
22/07/2019​
[/td][td]
21/08/2019​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
1900​
[/td][td=bgcolor:#FFFF00]
3990​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
9​
[/td][td]h[/td][td]
186​
[/td][td]
13/08/2019​
[/td][td]
12/09/2019​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
3534​
[/td][td=bgcolor:#FFFF00]
2232​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
10​
[/td][td]i[/td][td]
169​
[/td][td]
13/09/2019​
[/td][td]
9/10/2019​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
3042​
[/td][td=bgcolor:#FFFF00]
1521​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
11​
[/td][td]j[/td][td]
225​
[/td][td]
18/10/2019​
[/td][td]
12/11/2019​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
3150​
[/td][td=bgcolor:#FFFF00]
2700​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
12​
[/td][td]k[/td][td]
175​
[/td][td]
21/11/2019​
[/td][td]
18/12/2019​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
1750​
[/td][td=bgcolor:#FFFF00]
3150​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
13​
[/td][td]l[/td][td]
207​
[/td][td]
19/12/2019​
[/td][td]
8/01/2020​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
2691​
[/td][td=bgcolor:#FFFF00]
1656​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
14​
[/td][td]m[/td][td]
251​
[/td][td]
14/01/2020​
[/td][td]
9/02/2020​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
4518​
[/td][td=bgcolor:#FFFF00]
2259​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
15​
[/td][td]n[/td][td]
91​
[/td][td]
19/02/2020​
[/td][td]
########​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
1001​
[/td][td=bgcolor:#FFFF00]
2730​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
16​
[/td][td]o[/td][td]
105​
[/td][td]
########​
[/td][td]
########​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
1260​
[/td][td=bgcolor:#FFFF00]
2625​
[/td][td=bgcolor:#FFFF00]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
17​
[/td][td]p[/td][td]
74​
[/td][td]
15/04/2020​
[/td][td]
16/05/2020​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
0​
[/td][td=bgcolor:#FFFF00]
1184​
[/td][td=bgcolor:#FFFF00]
1184​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
18​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
19​
[/td][td]TOTAL[/td][td][/td][td][/td][td][/td][td]
2375​
[/td][td]
4401​
[/td][td]
3024​
[/td][td]
5520​
[/td][td]
1408​
[/td][td]
1766​
[/td][td]
4408​
[/td][td]
7524​
[/td][td]
5274​
[/td][td]
4671​
[/td][td]
4450​
[/td][td]
5841​
[/td][td]
6174​
[/td][td]
3260​
[/td][td]
3990​
[/td][td]
3809​
[/td][td]
1184​
[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Model[/td][/tr][/table]
 
Upvote 0
I wish I could just send you the sheet
Click to expand...
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.
 
Upvote 0
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.

Code: 
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Extending a formula to recognize an additional field regarding dates and months
2
Replies
17
Views
1K
JoeMo
J
M
  • Solved
Lookup & Concatenate subheading with details
Replies
4
Views
565
MurdochQuill
M
M
  • Question Question
automate the sheet
Replies
0
Views
348
mwvirk
M
P
  • Solved
Lookup based on multiple criteria
2 3
Replies
22
Views
934
paulkc
P
B
  • Question Question
Counting challenge with complex criteria
Replies
8
Views
771
Mackers
M

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top