Return Min Value with Index/Match if Min date is two or one month from today's date

[fbinaghi]

Hi Guys:

I have a rent roll for several properties which will have their rents increase over time. I would like to have my worksheet automatically update as those rent increase dates get closer to make sure I am billing them correctly. I am looking for an equation which will populate the next rent increase date column in sheet one with the next rent increase month coming up if that month is two or one months in the future from today's month and year for a given property. I want it to match the tenant in sheet one and look through the tenants in sheet two and match the minimum of the list of dates and compare it with today's month and year. If there isn't anything coming up within 1 or 2 months I want it to return blank. Thoughts?

SHEET 1

Unit	Tenant	Next Rent Increase Date	Increase Amount
100A	TRADER JOES
100B	STARBUCKS
100C	PIZZAHUT

SHEET 2

Today = 12/1/2019

Unit	Tenant	Next Rent Increase Date	Increase Amount
100A	TRADER JOES	01/01/2020	10,000
100A	TRADER JOES	06/01/2020	10,100
100A	TRADER JOES	01/01/2021	10,200
100A	TRADER JOES	06/01/2021	10,300
100A	TRADER JOES	01/01/2022	10,400
100B	STARBUCKS	01/01/2020	5,000
100B	STARBUCKS	06/01/2020	5,100
100B	STARBUCKS	01/01/2021	5,200
100B	STARBUCKS	06/01/2021	5,300
100B	STARBUCKS	01/01/2022	5,400