Return an array of data based on range of date
I can email the data file if you prefer since my requirement have change
slightly.
"Ken King" wrote:
The calendar is based on month
01/01/2009 02/01/2009 03/01/2009 ect.
"Shane Devenshire" wrote:
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?
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Ken King" wrote:
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
|