Help with a string of IF statements

Hi Jete,

I've ran a few trials of this and it's 99% there, thanks a million.

One small thing I've noticed is when the "lease break date" (Col E) is the same date as the last day in a period (the dates per row 2 - eg: 31/03/2020)the void period does not appear. I have attached an example of same with E6 demonstrating this, when I apply a different date which isn't the last day of a quarter then the model works fine and the void period present itself as it should.

Do you know why this might be?.

Thanks again