Return an array of data based on range of date

[Ken King]

I queried a database and put the following three columns in an Excel
worksheet tab, Suite Number, Occupant Name and Lease Expiration Date sorted
by Lease Expiration Date then Suite Number. I have a 5-year monthly calendar
in a separate worksheet tab that I want to list Suite Number(s) and Occupant
Name(s) within each columns Expiration month for the 5-year period. I want
to use a formula or function in each column on the 5-year monthly calendar
tab to return Suite Number and Occupant Name based on the range of dates
using the column header and adjacent column i.e. 1/1/2009 to 2/1/2009.

Is there a function to return an array of data in two of the three columns,
Suite Number and Occupant Name based on the month in the third Expiration
Date column?
Ken

 

[Shane Devenshire]

Hi,

Show us a sample of the way the 5-Year calendar looks?

Is it one long row 1/1/2008....12/1/2014
or is is
Jan ... Dec
2009
2010

And what are the actual entries in the calendar - numbers, dates, text?

 

[Ken King]

The calendar is based on month

01/01/2009 02/01/2009 03/01/2009 ect.

 

[Ken King]

I can email the data file if you prefer since my requirement have change
slightly.