Forum Discussion
Solved
Formula Assistance Crispin
I need assistance with multiple cells/formulas. 1) In the attached example C4 is the date required for the contractor to submit the CDRL. D4 is the actual date the CDRL was received. a) ...
See the attached version.
Thanks again for your assistance. I have two more columns to address; perhaps you could tackle this challenge as well.
1) In column I, row 4 (I4), I need a countdown that starts according to the date listed in column G, row 4 (G4), "IF" the word "Rejected" is in column H, row 4 (H4). If the word "Accepted" is listed no further action is required.
2) In column J, row 4 once a date is listed the countdown stops in I4 and the cell turns green, regardless if the countdown exceeded the 10 day marker.
Any assistance is very much appreciated!!
Regards,
Crispin
It's the same idea as for F4 - see the attached workbook.
- Thank you HansVogelaar!