I have a workbook with two sheets. On the first sheet are a series of dates.
On the second tab, I am trying to total the number of entries within
specific months using date ranges from the first sheet. I can't for the life
of me figure out what formula to use to do this. Can anyone help. An
example of the data I am trying to formulate would be a count of claims
1/31/10 but < 3/1/10. Please help. An example is below. I reposted as I didn't have an example in the first.


Here is an example of my workbook with the dates:



PIP Adjuster Claim Number System Insured Claimant Date Feature Received Date
Feature Reopened Date Feature Closed
1/22/10
3/8/10
2/9/10
7/14/10
On the second tab, I have each month listed and want to show a sum total of
the number of features received during each specific month.