I work with a small property management company, and we use Excel to track
where people are living as well as well as lease dates (when they start and
when they end)
What I would like to achieve, is to create another worksheet within the same
file that will show me whos lease is ending within the next 15 days from the
current date. I need it to show me the same information that I have in my
normal "rent roll".
To clarify things, I need an auto-populated list of all data associated with
dates that fall within 15 days!

My Lease End date is in column F on the tab "RENT ROLL"
I need all data in the rows that match =today() and 15 days out.

I don't know how clear this is, I'm hoping someone may understand!