COUNTIF criteria using date ranges?

Put your test dates in a cell, then use COUNTIF like so

=COUNTIF(A5:A30,"<="&A1)-COUNTIF(A5:A30,"<="&A2)



"Annie" wrote:

> How would I indicate that I want to count the number of dates fall
> between Date A and Date B? I looked in the other message threads about
> subtracting one COUNTIF from another, but I don't think it works for
> dates.
>
> Thank you,
> Annie
>
>

try
=sumproduct((rnga>a1)*(rngA<b1))

--
Don Guillett
SalesAid Software
donaldb@281.com
"Annie" <ashapren@yahoo.com> wrote in message
news:1125078145.279053.146190@z14g2000cwz.googlegroups.com...
> How would I indicate that I want to count the number of dates fall
> between Date A and Date B? I looked in the other message threads about
> subtracting one COUNTIF from another, but I don't think it works for
> dates.
>
> Thank you,
> Annie
>

This also works

=COUNTIF(P1:P10,"<01/03/2005")-COUNTIF(P1:P10,"<01/02/2005")

but make sure that you format the cell as general as it tends to try and
force date format.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Duke Carey" <DukeCarey@discussions.microsoft.com> wrote in message
news:8D42FC5E-1D43-49FB-8B67-BD9649BFD387@microsoft.com...
> Put your test dates in a cell, then use COUNTIF like so
>
> =COUNTIF(A5:A30,"<="&A1)-COUNTIF(A5:A30,"<="&A2)
>
>
>
> "Annie" wrote:
>
> > How would I indicate that I want to count the number of dates fall
> > between Date A and Date B? I looked in the other message threads about
> > subtracting one COUNTIF from another, but I don't think it works for
> > dates.
> >
> > Thank you,
> > Annie
> >
> >

Put your test dates in a cell, then use COUNTIF like so

=COUNTIF(A5:A30,"<="&A1)-COUNTIF(A5:A30,"<="&A2)



"Annie" wrote:

> How would I indicate that I want to count the number of dates fall
> between Date A and Date B? I looked in the other message threads about
> subtracting one COUNTIF from another, but I don't think it works for
> dates.
>
> Thank you,
> Annie
>
>

try
=sumproduct((rnga>a1)*(rngA<b1))

--
Don Guillett
SalesAid Software
donaldb@281.com
"Annie" <ashapren@yahoo.com> wrote in message
news:1125078145.279053.146190@z14g2000cwz.googlegroups.com...
> How would I indicate that I want to count the number of dates fall
> between Date A and Date B? I looked in the other message threads about
> subtracting one COUNTIF from another, but I don't think it works for
> dates.
>
> Thank you,
> Annie
>

This also works

=COUNTIF(P1:P10,"<01/03/2005")-COUNTIF(P1:P10,"<01/02/2005")

but make sure that you format the cell as general as it tends to try and
force date format.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Duke Carey" <DukeCarey@discussions.microsoft.com> wrote in message
news:8D42FC5E-1D43-49FB-8B67-BD9649BFD387@microsoft.com...
> Put your test dates in a cell, then use COUNTIF like so
>
> =COUNTIF(A5:A30,"<="&A1)-COUNTIF(A5:A30,"<="&A2)
>
>
>
> "Annie" wrote:
>
> > How would I indicate that I want to count the number of dates fall
> > between Date A and Date B? I looked in the other message threads about
> > subtracting one COUNTIF from another, but I don't think it works for
> > dates.
> >
> > Thank you,
> > Annie
> >
> >

Put your test dates in a cell, then use COUNTIF like so

=COUNTIF(A5:A30,"<="&A1)-COUNTIF(A5:A30,"<="&A2)



"Annie" wrote:

> How would I indicate that I want to count the number of dates fall
> between Date A and Date B? I looked in the other message threads about
> subtracting one COUNTIF from another, but I don't think it works for
> dates.
>
> Thank you,
> Annie
>
>

try
=sumproduct((rnga>a1)*(rngA<b1))

--
Don Guillett
SalesAid Software
donaldb@281.com
"Annie" <ashapren@yahoo.com> wrote in message
news:1125078145.279053.146190@z14g2000cwz.googlegroups.com...
> How would I indicate that I want to count the number of dates fall
> between Date A and Date B? I looked in the other message threads about
> subtracting one COUNTIF from another, but I don't think it works for
> dates.
>
> Thank you,
> Annie
>

This also works

=COUNTIF(P1:P10,"<01/03/2005")-COUNTIF(P1:P10,"<01/02/2005")

but make sure that you format the cell as general as it tends to try and
force date format.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Duke Carey" <DukeCarey@discussions.microsoft.com> wrote in message
news:8D42FC5E-1D43-49FB-8B67-BD9649BFD387@microsoft.com...
> Put your test dates in a cell, then use COUNTIF like so
>
> =COUNTIF(A5:A30,"<="&A1)-COUNTIF(A5:A30,"<="&A2)
>
>
>
> "Annie" wrote:
>
> > How would I indicate that I want to count the number of dates fall
> > between Date A and Date B? I looked in the other message threads about
> > subtracting one COUNTIF from another, but I don't think it works for
> > dates.
> >
> > Thank you,
> > Annie
> >
> >

How would I indicate that I want to count the number of dates fall
between Date A and Date B? I looked in the other message threads about
subtracting one COUNTIF from another, but I don't think it works for
dates.

Thank you,
Annie

Put your test dates in a cell, then use COUNTIF like so

=COUNTIF(A5:A30,"<="&A1)-COUNTIF(A5:A30,"<="&A2)



"Annie" wrote:

> How would I indicate that I want to count the number of dates fall
> between Date A and Date B? I looked in the other message threads about
> subtracting one COUNTIF from another, but I don't think it works for
> dates.
>
> Thank you,
> Annie
>
>

try
=sumproduct((rnga>a1)*(rngA<b1))

--
Don Guillett
SalesAid Software
donaldb@281.com
"Annie" <ashapren@yahoo.com> wrote in message
news:1125078145.279053.146190@z14g2000cwz.googlegroups.com...
> How would I indicate that I want to count the number of dates fall
> between Date A and Date B? I looked in the other message threads about
> subtracting one COUNTIF from another, but I don't think it works for
> dates.
>
> Thank you,
> Annie
>

This also works

=COUNTIF(P1:P10,"<01/03/2005")-COUNTIF(P1:P10,"<01/02/2005")

but make sure that you format the cell as general as it tends to try and
force date format.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Duke Carey" <DukeCarey@discussions.microsoft.com> wrote in message
news:8D42FC5E-1D43-49FB-8B67-BD9649BFD387@microsoft.com...
> Put your test dates in a cell, then use COUNTIF like so
>
> =COUNTIF(A5:A30,"<="&A1)-COUNTIF(A5:A30,"<="&A2)
>
>
>
> "Annie" wrote:
>
> > How would I indicate that I want to count the number of dates fall
> > between Date A and Date B? I looked in the other message threads about
> > subtracting one COUNTIF from another, but I don't think it works for
> > dates.
> >
> > Thank you,
> > Annie
> >
> >