I respectfully stand by my formula - as well as the assertion that mm/dd/yy format can be used in conditional expressions inside the countif function.
On 11/3/05, Anthony Chilco <[EMAIL PROTECTED]> 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 > >>> > >>> > >>> > >>>--------------------------------------------------------------------- > >>>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>For additional commands, e-mail: [EMAIL PROTECTED] > >>> > >>> > >>> > >>> > >>-- > >>My OpenOffice Calc Website > >>http://www.openofficetips.com > >> > >> > >> > > > > > >-- > >My OpenOffice Calc Website > >http://www.openofficetips.com > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
