View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Craig Craig is offline
external usenet poster
 
Posts: 208
Default 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