"Void" Periods should apply and follow the Lease Break date (specified in Column E) and Lease Expiry dates (specified in Column F) for the amount of periods specified in "Column J".
I guess that I am still confused. Based on the above from post #22, it would seem that since the lease break date for example 1 (12/9/2020) is in Q4 2020 that Q1 2021 should be as void and since the lease expiry date (2/10/2021) is in Q1 2021 that Q2 2021 should also show as void. I see that the formula is displaying void for the wrong quarters, just not sure why it should not show void for two quarters instead of one.