You could easily get this info using a Pivot table. Once you have the dates
right click on a date on the Pivot table and select "group and show
detail"-- group and select month+Year
Google it if you are unsure how to create a Pivot table

"Ken King" wrote:

I have a worksheet tab with the following three columns sorted by Expire Date
with over 500 rows of data.
A B C
Expire Suite #
Date Occupant RSF
3/31/2009 105: Name A 100
1/10/2010 210: Name B 200
2/15/2011 107: Name C 150

I have a 10 year calendar on another worksheet tab (example below) for
presenting expirations by month/year with Suite #: Occupant and RSF (rentable
square feet).

A B C D E
F...
1/1/2009 2/1/2009 3/1/2009€¦ 12/1/2009
105: Name A 100

1/2/2010 2/1/2010 3/1/2010€¦ 12/1/2010
210: Name B 200


1/1/2011 2/1/2011 3/1/2011€¦ 12/1/2011
107: Name C 150

I am trying to write a formula or function to find expiration dates each
calendar month for the 10-year period and return the €˜Suite #: Occupant in
the column below the date and €˜RSF in the adjacent column. Is it possible
to do a lookup for a calendar date i.e. 1/1/2009 to 1/31/2009 etc. and return
the corresponding 'Suite #: Occupant' and 'RSF' columns?
Thanks,
Ken