Real Estate Rent Roll

This will work for all of your 5 year leases. Just paste into column G33, then if you add a new 5 year lease copy and paste formula into the column G of the appropriate new row.

=IF(TODAY()<N24,O23,IF(TODAY()<N25,O24,IF(TODAY()<N26,O25,IF(TODAY()<N27,O26,IF(TODAY()>N27,O27,O23)))))

Alternately

=IF(A2<N34,O33,IF(A2<N35,O34,IF(A2<N36,O35,IF(A2<N37,O36,IF(A2>N37,O37,O33)))))