Real Estate Rent Roll

I'm trying to avoid manually each period to update my company's rent roll. I have highlighted starbucks as an example. The current rent is $3,200(G33) which is the old rent amount from 9/1/2012(M33). The rent should be $3,296(N34) since 9/1/2013(M34). I have added =Today() formula(A2). Can someone please guide me on a formula to input into (G33) that will automatically look at the current date (A2) and calculate date base off M33:M37 and choose the appropriate rental amount in cells N33:N37? Thanks excel forum! The worksheet is attached.