View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark R[_2_] Mark R[_2_] is offline
external usenet poster
 
Posts: 10
Default Countind date between two dates - formula results

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.

I need this as a formula so that I can populate graphes etc with it.