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.