| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date count
Hello everybody :-)
Let say I have these data: Centre Name Date Open Santa Maria August 2004 St. Loius April 2006 Greenlane March 2002 North Point December 2005 South Point May 2006 This is a part of the data that I have. My question a 1) How to count how many centre open before 2006? 2) To list the centre open before/after 2006 3) To list of centre that have operated 1 year or more? Thanks (^_^) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count the number of days from 1 date to another? | Excel Discussion (Misc queries) | |||
| count the number of cells within a column with a date <= today's d | New Users to Excel | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
| How do I count occurences in a date range? | Excel Worksheet Functions | |||
| Count the occurances of a month in a range of date fields | Excel Worksheet Functions | |||
Threaded Mode
