How to make mtd and wtd totals on dates
 

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??


--
ashley0578
------------------------------------------------------------------------
ashley0578's Profile: http://www.excelforum.com/member.php...o&userid=32757
View this thread: http://www.excelforum.com/showthread...hreadid=525900