Lookup date range

Hello All,

I want to lookup one table within date range in another table. 

Could you share with me any formulas can use? Below is the sample, I need to fill up the payment date under column B. Thanks!

eg: sales date on 01 Jan, Payment date falls within the sales date range 26/12-01/01, payment date on 09 Jan