Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting data between dates
On Jul 29, 10:50 am, Mark R <Mark
wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting data between dates
Sun, 29 Jul 2007 08:50:01 -0700 from <?B?TWFyayBS?= <Mark
: 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. -- "The Internet is famously powered by the twin engines of bitterness and contempt." -- Nathan Rabin, /The Onion/ Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting dates | Excel Discussion (Misc queries) | |||
counting occasions dates occur between 2 dates | New Users to Excel | |||
Counting Dates..is it possible? | New Users to Excel | |||
Counting dates, within a list of dates | Excel Worksheet Functions | |||
Counting data columns with dates | Excel Discussion (Misc queries) |