Return an array of data based on range of date

  • Thread starter Thread starter Ken King
  • Start date Start date
K

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
 
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?
 
Back
Top