Re: Re: Is there a way to count the number of cells in a column containing a date within a specified range?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: Re: Is there a way to count the number of cells in a column containing a date within a specified range?

Fred Grant
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 <[hidden email]> 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 <[hidden email]> 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: [hidden email]
For additional commands, e-mail: [hidden email]