Besides for that one thing from the last post. I'm noticing that its not noticing the right columns. If the date criteria is met then its suppose to check Columns G and I to see if they have any values in them. If either one of those columns do. Then Column H wont receive anything. If both columns G and I are empty after the date criteria is met then Column H will receive a "yes".