Calculate Range with automatic defined dimension

[earthworm]

I need to calculate profit based on defined range . That is to multiple all data days from 6 column and multiple it by 6 column however on the last column I want the second last rate to apply on the last column . Please help I tried every possible technique i know and still couldnt figure it out . Please help

P.S : I am using office 2016

Calculation.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
2	Booking Date	Maturity Date	Days	Amount	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21
3	04-03-2021	08-08-2021	157	500,000.00	5.00%	5.50%	6.00%	6.25%	4.50%	7.40%	6.30%	6.20%	7.00%
4
5				Days			28	30	31	30	31	7	157
6				Answer			2,301.37	2,568.49	1,910.96	3,041.10	2,675.34	594.52	13,091.78	(A)
7				Required Answer			2,301.37	2,568.49	1,910.96	3,041.10	2,675.34	604.11	13,101.37	(B)	<<< This is what I want
8
9				Single Formula Answer			13,091.78	(A)
10
11				Required Answer			13,101.37	(B)
Sheet1

Cell Formulas
Range	Formula
C3	C3	=B3-A3
M5:M7	M5	=SUM(G5:L5)
G6:L6	G6	=G3/365*G5*$D$3
G7:K7	G7	=G3/365*G5*$D$3
L7	L7	=K3/365*L5*$D$3
G9	G9	=SUMPRODUCT(INDEX(E3:M3,MATCH(DATE(YEAR(ROW(INDIRECT(A3&":"&B3-1))),MONTH(ROW(INDIRECT(A3&":"&B3-1))),1),$E$2:$M$2,1))/365)*D3
G11	G11	=M7