Need to create a formula that counts dates
 

I have a complaints database that measures trends. One of the trends we will
be looking at is how many complaints were opened per week. The dates each
complaint is opened uses this format 12-Nov-07.
I need to count all the complaints opened in a particular week using the
standard five day working week (mon-fri) for 52 weeks a year.

Thanks in advance
Craig

Need to create a formula that counts dates
 

Craig,

With your list of dates in A1 - A200.
Start date (12/11/2007) in B1
End date (16/11/2007) in B2
try this formula

=COUNTIF(A1:A200,"="& B1)-COUNTIF(A1:A200,"="& B2)

Mike

"Craig" wrote:

I have a complaints database that measures trends. One of the trends we will
be looking at is how many complaints were opened per week. The dates each
complaint is opened uses this format 12-Nov-07.
I need to count all the complaints opened in a particular week using the
standard five day working week (mon-fri) for 52 weeks a year.

Thanks in advance
Craig

Need to create a formula that counts dates
 

That should of course have been

=COUNTIF(A1:A20,"="& B1)-COUNTIF(A1:A20,""& B2)

Mike

"Craig" wrote:

I have a complaints database that measures trends. One of the trends we will
be looking at is how many complaints were opened per week. The dates each
complaint is opened uses this format 12-Nov-07.
I need to count all the complaints opened in a particular week using the
standard five day working week (mon-fri) for 52 weeks a year.

Thanks in advance
Craig