Get result based on dates and assumption

[Muthukrishnan V]

Based on dates and assumption.xlsx
	A	B	C	D	E	F	G
1	dd-mm-yyyy		Formula Request			dd-mm-yyyy
2	Date	Reading	to get Result			Date	Assumption
3	16-06-2020	1275.00	135.00	B3-G3		20-05-2020	1140.00
4	14-07-2020	1360.00	220.00	B4-G3
5	19-08-2020	1520.00	40.00	B5-G4		21-07-2020	1480.00
6	11-09-2020	1611.00	131.00	B6-G4
7	22-09-2020	1744.66	4.66	B7-G7		21-09-2020	1740.00
8	27-09-2020	1814.00	74.00	B8-G7		27-11-2020	2220.00
9	30-09-2020		Blank	" "
10	28-12-2020		Blank	" "
Sheet1

Excel 365
Kindly help me with a formula in Column C. Taking into account dates in Column A and B, output required in Column C, which should be based on relevant dates in
Columns F and G. Thanking you,

 

[Muthukrishnan V]

Sir, Sorry. There is a mistake. D5=B5-G5. D6=B6-G5. I request you to excuse me.

 

[Special-K99]

Try
in C3
IF(B3="","",B3-LOOKUP(2,1/(((F$3:F$1000)<>"")*(A3>F$3:F$1000)),G$3:G$1000))

 

[Muthukrishnan V]

Excellent!. My problem resolved. Thanking you Mr. Special-K99 sir, I am grateful to our Forum.

 

[Muthukrishnan V]

Dear sirs, I may kindly be excused for reopening the issue. In C3 I get 1275(B3) and not 135(B3-G3). Can you please help me.
I once again request I may be pardoned if it is not permitted to reopen the thread. Thanking you, sirs.

 

[Special-K99]

Compare what you've typed with my solution, it works. I have 135 in C3.
All figures are exactly as you've requested.

 

[kvsrinivasamurthy]

In B3

=LET(rb,B3:B10,rg,G3:G10,da,A3:A10,df,F3:F10,MAP(rb,da,ROW(rb),LAMBDA(x,y,z,IF(x="","",LET(a,LARGE(IF((rg<>"")*(ROW(rg)<=z)*(df<=y),ROW(rg),""),1)-ROW(G2),b,INDEX(rg,a),IF(x="","",x-b))))))

 

[kvsrinivasamurthy]

Improved formula in B3

=LET(rb,B3:B10,rg,G3:G10,da,A3:A10,df,F3:F10,MAP(rb,da,LAMBDA(x,y,IF(x="","",x-INDEX(rg,LARGE(IF((df<>"")*(df<=y),ROW(rg),""),1)-ROW(G2))))))

 

[Muthukrishnan V]

Thank you Special-K99 sir and kvsrinivasamurthy sir. I get the answer. I am grateful to the forum.