Sully1440
07-25-2018, 10:12 AM
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 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