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]
