Want to find the nearest date

[vishu]

N5 to N	O5 to O	Result
	01-01-2025	01-01-2025
	01-02-2025	21-01-2025
	01-03-2025	26-01-2025
	01-04-2025	27-01-2025
	01-05-2025
21-01-2025
26-01-2025
27-01-2025

Hello friends, I have Two columns N and O. N is paid date and O is suppose to pay date. Need formula want to find the nearest date so the result should look like shown in Result header

 

[vishu]

Friends let me explain please provide formula please
Column O5 to O (Should Pay) captures the due date which is for each month, the repayment date.
Column N5 to N (Paid) Contains the actual Paid date.

Now, for each should pay date in column O, want to have the latest Paid date from column N. Need formula for this logic which will calculate the nearest paid date for each “should pay” date in column O with the aid of ‘minimum’. It calculates the absolute difference between the should pay date and all paid dates.

Paid	should pay	Sort Nearest Date Formula
	01-01-2025	01-01-2025
	01-02-2025	21-01-2025
	01-03-2025	26-01-2025
	01-04-2025	27-01-2025
	01-05-2025
21-01-2025
26-01-2025
27-01-2025

 

[vishu]

If this is so difficult or may be you guys are busy solving, helping bigger problems. Please allow me to ask same question some other forums Please

 

[Fluff]

Please allow me to ask same question some other forums Please

That's fine as long as you post a link here to any other site where you ask the question.

 

[vishu]

Thanks please below link where asked same question

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)

www.excelforum.com

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