Saturday, July 20, 2013

yogi_Compute Leased Square Footage By Tenant Expiring Within Specified Number Of Months from Today

                                          Google Spreadsheet   Post  #1298
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jul 21, 2013

This relates to a solution I had posted back in 2008 to a question
 in help forum wherein I had used Excel's DataTable feature. Today I was prompted for solution to a followup question by cdh121 from that thread in 2008 -- but this time I used Google's QUERY function for a solution to the original question as well as the followup question

user post by elmsley4 and followup question by cdh121 (

I am going to ask sort of the same question, for the same type of spreadsheet: I have a sheet containing the same basic data (square footages in Column C, Expiration Dates in Column E). But, I want to be able to see how much square footage is expiring within 6 months of TODAY, 12 months of TODAY, etc., with the total SF for each date range summing into one cell. Bonus points for conditional formatting that will highlight the names of tenants (in Column B) whose lease are expiring in those ranges.