How to count the number of cells before a condition is met?

Thanks FGibbins, that would work perfectly if the structure of the data is as you assumed!

However, what I meant was one different date for each row... I have updated the example in a new attachment. This makes it much harder, at least in my mind...