Find the value of the due date falls between two dates

I want to transfer data in the red column
In the cell green if the date is equal to the year with a year maturity

have done a formula, please check is it helpful.

Thank you very much for this wonderful solution