I am trying to create an if statement that has several different
factors. Here is what I am trying to do: If A2(status) = Open and
AB2(Category) = CMRA or MRC-PARTS and the D2 (date created) is greater
then 8 days then populate "yes", however if it does not reach this
criteria then populate "no".

Is this even possible?

Please advise,