Find the value of the due date falls between two dates

[mahmoud-lee]

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

[aju.thomas]

have done a formula, please check is it helpful.

[mahmoud-lee]

Thank you very much for this wonderful solution