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