Counting data between dates

[Guest]

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

 

[ed]

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

Use, from the Data Menu, Filter /Auto_Filter and or Sort. You can
do almost anything with these powerfull tools.

ed

 

[Stan Brown]

Sun, 29 Jul 2007 08:50:01 -0700 from <=?Utf-8?B?TWFyayBS?= <Mark
(e-mail address removed)>>:

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

Please don't post the same question multiple times.