Forum Discussion
How to summarize dates on a cover sheet
Hello all, I currently have 2 sheets that are in the general format of: Client Name | Upcoming Date | Type Both spreadsheets are within the same file and I would like to add a cover she...
The difficult part is in collating data from multiple sheets. Maybe one of the experts will join the conversation. (It may be better to combine and maintain all the data into one new worksheet, and use the function mentioned below to get the content of your two existing worksheets plus the cover sheet.)
Your request as stated does not involve summarization on dates, but filtering on dates. The key to (this part of) the solution is the FILTER function. If your data is in the range A2:C20 (and assuming your Upcoming Date data in column B is stored as dates, not as text), the cover sheet formula to retrieve the subset from one worksheet might be:
=FILTER( Sheet2!$A$2:$C$20, (Sheet2!$B$2:$B$20 >= TODAY()) * (Sheet2!$B$2:$B$20 < TODAY()+7), "" )This is not guaranteed to work as written; I do not have Excel for Mac.