I don't see any of those dates in your sample file. I am trying to figure out why your formula is not working (to me it seems correct based on the logic I am assuming you are looking for) but I can't determine that if I don't match your expected results to your formula output.