Need to create a formula that counts dates

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating complaints more than 10 days old 1
counting how many times something happens in a week 4
dates inside macro - help pls 3
Passing text into a formula? 8
Date formulas 7
I need to use the same fomula each week after saving 2
need a formula 1
Nested hlookup/vlookup (possibly just an if statement though?!?) 1

Back
Top