I have three spreadsheets named unfunded, funded and recap. My recap sheet gives different sets of totals. I'm able to get the complete totals to work by using =COUNT('unfunded deals'!A:A). The next total is for month-to-date. I've not been able to figure out how to write it. In access, I would create a query and use date()-30 to get the last 30 days. The same for the week. How can I make this happen??