On Thu, 2005-11-03 at 15:25, Anthony Chilco wrote: > Hi David and Robert, > > It should be: > > =(COUNTIF(A1:A100;"<10/17/02")+COUNTIF(A1:A100;">10/23/02"))-COUNT(A1:A100) > > Except that you can't use date formats if the cells you're counting contain > real dates. You'll have to use the numbers that represent the dates: > > Date Date as number Add comparison operator > 12/29/05 38715.64 >38715.6362420139 > > So it looks like: > > =COUNTIF(A1:A100;">38715.6362420139")+COUNTIF(A1:A100;"<39079.6362420139")-COUNT(A1:A100) > > tc > > > David Chapman wrote: > > >Should be.. > > > >=COUNT(A1:A100)-(COUNTIF(A1:A100;"<10/17/02")+COUNTIF(A1:A100;">10/23/02")) > > > >On 11/3/05, David Chapman <[EMAIL PROTECTED]> wrote: > > > > > >>Example, > >> > >>Count cells between 10/17/02 and 10/23/02 inclusive... > >> > >>=COUNTIF(A1:A100)-(COUNTIF(A1:A100;"<10/17/02")+COUNTIF(A1:A100;">10/23/02")) > >> > >>On 11/3/05, Robert Volke <[EMAIL PROTECTED]> wrote: > >> > >> > >>>I've looked all over and I can't seem to figure out how to count the > >>>number of cells in a column that contain a date within a specific date > >>>range, aside from manually counting them. I can do this, but it would > >>>make life much easier to have this information automatically populated > >>>in my summary sheet upon each update. There may a function that I can > >>>use to count these occurrence but I have been unable to determine it so > >>>far. Thank you for your help. > >>> > >>>Robert > >>> > >>> > >>> I'm using 1.1.2 and I can use the dates OK, at least in a simple example to count those greater than a certain date. It would be nice to be able to incorporate an "and" into the expression.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
