Formula to find the earliest date in excel base on a given date and text

Hello,

I would like to ask if anyone can help me figure out the formula to easily capture the necessary information.

This is what im trying to accomplish, in the attached file i would like to get the earliest date "payment run date (column E)" base on the contract end date (column D) considering the payment run date for US and CAN (column H and I).

i was able to get the earliest date using =MIN(IF(I:I>D2,I:I)) , but having a hard time adding criteria to separate the payment run date for US and CAN data.

In short, i want a formula to get the earliest payment run considering the contract end date while also considering the schedule of payment run per country.

line #9 CAN should get 02/02/17 and not the 01/02/2017 which is for US.

Bare with my grammar folks.


Thank you
Rikii