Good morning NBVC

The reason why the third line would not have a Y is because it is over a year since the first occurance. The second occurance is within a year, but when you look at the dates, the third one is more than a year. Based on review theres really not that many so I can just go through the list and manually correct those using your original formula which as I said previously worked like a charm.

Thanks