View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark R Mark R is offline
external usenet poster
 
Posts: 2
Default Counting data between dates

I have a spreadsheet that has clients names and then the date that I
submitted the business for them i.e

Mr Jones 12/12/2006 Abbey
Mrs Smith 12/01/2007 Natwest

What is the best way to count all the submitted business in 1 month say for
January only. Also how would i count all the Abbey cases in say 2007, or 2006