I am trying to return a # of leads issued to a salesperson based on a range
of dates from their worksheet to a master worksheet.

the formula i have is: =COUNTIF('SalesPerson'!A2:A500,DATE(2006,1,24))

this works and returns all the leads issued on 1/24/2006 just fine. but i
want to return the # of leads for the entire MONTH (January in this case).
the worksheet i'm trying to pull from is set up:

A2 1/24/2006
A3 1/24/2006
A4 1/26/2006
A5 2/1/2006