Monthly Scope Distribution using IF Formula

[loginid]

Dear friends,

In the below sheet "Balance Scope" needs to be distributed monthwise based on Start date and Finish date columns automatically.
requirement is: if "Done" E column is >0 and Data Date (G2) is > subsequent months (i.e. L5,M5,N5,O5,P5......) then balance scope should be distributed in the remaining months
And previous month plan values should NOT change.

Copy of Petrapole_ Tracker_KKD.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1							Data Date
2							30-09-20
3												31-07-20
4	Seg-1 Grid Q-X/4-8 (1/3rd Area)						Latest Tracked as on Jun-20		Per day Qty
5	Sl No	Activity	Unit	Scope	Done	Balance	Start	Finish			Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21	Total	% Complete
6	1	Piling	Nos	625	2	623	23-Jul-20	12-Sep-20	12.22	Plan	-	98	379	147	-	-	-	-	-	-	623	0.32%
7										Achieved	2										2
8	2	Sheet Piling	Rmt	278	-	278	26-Jun-20	2-Sep-20	4.09	Plan	16	127	127	8	-	-	-	-	-	-	278
9										Achieved											-
10	3	Excavation	Cum	27173	-	27,173	2-Sep-20	14-Oct-20	646.98	Plan	-	-	-	18,115	9,058	-	-	-	-	-	27,173
11										Achieved											-
12	4	Metal Filling	Cum	1595	-	1,595	15-Oct-20	30-Oct-20	106.33	Plan	-	-	-	-	1,595	-	-	-	-	-	1,595
13										Achieved											-
14	5	PCC	Cum	445	-	445	17-Oct-20	1-Nov-20	29.67	Plan	-	-	-	-	415	30	-	-	-	-	445
15										Achieved											-
16	6	RCC FDN	Cum	7950	-	7,950	20-Oct-20	25-Nov-20	220.83	Plan	-	-	-	-	2,429	5,521	-	-	-	-	7,950
17										Achieved											-
18	7	RCC Col , Wall,Deck slab	Cum	1875	-	1,875	23-Oct-20	22-Dec-20	31.25	Plan	-	-	-	-	250	938	688	-	-	-	1,875
19										Achieved											-
20	8	Filling	Cum	1043	-	1,043	4-Feb-21	16-Mar-21	26.06	Plan	-	-	-	-	-	-	-	-	626	417	1,043
21										Achieved	-										-
Tracker-PTB (2)

Cell Formulas
Range	Formula
E6,E20,E18,E16,E14,E12,E10,E8	E6	=SUM(K7:T7)
F6,F20,F18,F16,F14,F12,F10,F8	F6	=D6-E6
G16:H16,G6:H6	G6	='TCP-PTB'!H23
K6	K6	=MIN(IF($G6<K$5,(K$5-$G6)*$I6,0),$D6)
L6,L20:T20,L18:T18,L16:T16,L14:T14,L12:T12,L10:T10,L8:T8	L6	=MIN(IF($G6<L$5,(L$5-$G6)*$I6,0),$F6)-SUM($K6:K6)
M6:T6	M6	=IF($E6>0,IF($G$2>M5,MIN(IF($G6<M$5,(M$5-$G6)*$I6,0),$D6)-SUM($K6:L6),MIN(IF($G6<M$5,(M$5-$G6)*$I6,0),$F6)-SUM($K6:L6)),"")
V6,V20,V18,V16,V14,V12,V10,V8	V6	=IF((U7/U6)>0,U7/U6,"")
G8:H8	G8	='TCP-PTB'!H28
K8,K20,K18,K16,K14,K12,K10	K8	=MIN(IF($G8<K$5,(K$5-$G8)*$I8,0),$F8)
G12:H12,G10:H10	G10	='TCP-PTB'!H29
G14:H14	G14	='TCP-PTB'!H32
G18	G18	='TCP-PTB'!H34
H18	H18	='TCP-PTB'!I34+15
D20	D20	=278*0.75*5
G20:H20	G20	='TCP-PTB'!H131
I6,I20,I18,I16,I14,I12,I10,I8	I6	=F6/(H6-G6)
U6:U21	U6	=SUM(K6:T6)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
V6,V8,V10,V12,V14,V16,V18,V20,V25,V27,V29,V31,V33,V35,V37,V39,V44,V46,V48,V50,V52,V54,V56,V63,V65,V67,V69,V71,V73,V75,V77,V58	Other Type	DataBar		NO

Formula tried : M6 Cell =IF($E6>0,IF($G$2>M5,MIN(IF($G6<M$5,(M$5-$G6)*$I6,0),$D6)-SUM($K6:L6),MIN(IF($G6<M$5,(M$5-$G6)*$I6,0),$F6)-SUM($K6:L6)),"")

Thanks