Date Lookup Problem

Hi All,
I need your help with a formula to check dates and input a status in a cell. I want the formula to do the following:
1.) If there is a checkmark in the range D4:I4, AND
2.) If the corresponding date in range D2:I2, is greater than today's date, THEN
3.) Cell J4 = "Behind Schedule"

I'd like this formula in each cell for column J compared to the date range in D2:I2. I attached the sample spreadsheet.

I'm thinking this is an if statement with an Index and Match formula, .....or a sumproduct formula but I'm stuck.

Any help would be appreciated.
Thanks,
Jim

I figured it out :thumb :banghead:

=IF((INDEX(DueDate,MATCH("ü",D4:I4,0)))< NOW(), "Behind Schedule", "On Track")