Find and sort nearest date

Hello friends need excel formula please help me

Sheet Name "Entry" A3 to C1000
Date ID Member Name


Sheet Name "L001"

Loan Date ($B$2), Interest % ($C$2), Loan Amount ($D$2), Tenor ($E$2), Loan ID: ($G$1), Name ($F$2)



Intrest Paid Date
A5 to A100 (Need Formula)

Suppose to Pay Date
B5=IF(C5="", "", DATE(YEAR($B$2),MONTH($B$2)+C5,DAY($B$2)))
B5 to B100 data is
01-01-2025
01-02-2025
01-03-2025
01-04-2025
01-05-2025

Tenor
c5=1
c6=2
c7=3
c8=4
c9=5
and so on

Need formula for (Intrest Paid Date) A5 to A100

Find the closest "Intrest Paid Date" date for each "Suppose to Pay Date" (B5 to B100), provide a formula
So helper is in "Entry" sheet F3 to F1000
=IF(ISNUMBER('L001'!B5), ABS(A3 - 'L001'!B5), "") Drag down
000
031
059
090
120



I tried below formula in sheet "L001" for A5 and Drag down
=IFERROR(
INDEX(Entry!$A$3:$A$1000,
MATCH(MIN(IF((Entry!$B$3:$B$1000=$G$1)*(Entry!$C$3:$C$1000=$F$2), Entry!$F$3:$F$1000, 1E+30)),
IF((Entry!$B$3:$B$1000=$G$1)*(Entry!$C$3:$C$1000=$F$2), Entry!$F$3:$F$1000, 1E+30),
0)
),
""
)
But wrong result Result. Needed correct formula to achieve below result

Sort Nearest Date Formula Suppose to Pay Date
01-01-2025 01-01-2025
21-01-2025 01-02-2025
26-01-2025 01-03-2025
27-01-2025 01-04-2025

Note: Same question asked in https://www.mrexcel.com/board/thread...-date.1269135/

Friends also attaching Testing sheet for your refrence please check Yellow mark sheets and yellow marked columns

One guess,
A5

Please Login or Register  to view this content.

copied down.

Thanks you tried
But It should match
"L001" Sheet $G$1 = "Entry" Sheet B:B
and
"L001" Sheet $F$2= "Entry" Sheet C:C
After matching then finding dates from
"Entry" Sheet A:A = place the formula with sorted dates in A5 to A100 "L001" Sheet

Amazing thank you, thank you very much