I am making an Excel 2010 spreadsheet to log support calls, services, and installations that each member would fill out. Due to being paid by job rather than by hour, there is a need for it to count each of these ("Call", "Service", "Install") there is in any given time span. The entry of the data itself would be in Sheet 1, and then a 'splash screen' of sorts would be in Sheet 2. Here I would like to be able to put a date range and it would display how many of each there is. I already can do the COUNTIF statement,

=COUNTIF(Activity!$B:$B,"Call")

but I don't know how to:

a) Add in the prerequisite for a date so it only gets "Calls" within a certain time frame.

b) Take the date it looks for from a cell on the splash screen.