Hi All,

At present I have a formula that counts the number of date entries in
a column.

=COUNT($AL$1000:$AL$5000,"<=today()")

I need to change it so that it counts the dates between today and the
last 3 months.

Can someone tell me how, I have tried all manner of configurations.

Many thanks

Joe

Give this a try: Watch for the word wraping below

=COUNTIF($AL$1000:$AL$5000,"<="&TODAY())-COUNTIF($AL$1000:$AL$5000,"<="&DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY())))

HTH

"deaconj999" wrote:

> Hi All,
>
> At present I have a formula that counts the number of date entries in
> a column.
>
> =COUNT($AL$1000:$AL$5000,"<=today()")
>
> I need to change it so that it counts the dates between today and the
> last 3 months.
>
> Can someone tell me how, I have tried all manner of configurations.
>
> Many thanks
>
> Joe
>
>

This may work

=COUNTIF($AL$1000:$AL$5000,"<"&DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY())))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(E-Mail Removed)DTHIS
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

"deaconj999" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
>
> At present I have a formula that counts the number of date entries in
> a column.
>
> =COUNT($AL$1000:$AL$5000,"<=today()")
>
> I need to change it so that it counts the dates between today and the
> last 3 months.
>
> Can someone tell me how, I have tried all manner of configurations.
>
> Many thanks
>
> Joe
>

If OP has Future Dates in Column A, wouldn't they also be included in the
count (He wanted to limit from 3 months back to today)?

"Nick Hodge" wrote:

> This may work
>
> =COUNTIF($AL$1000:$AL$5000,"<"&DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY())))
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> (E-Mail Removed)DTHIS
> web: www.nickhodge.co.uk
> blog: www.nickhodge.co.uk/blog/
>
> FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
> www.officeusergroup.co.uk
>
> "deaconj999" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi All,
> >
> > At present I have a formula that counts the number of date entries in
> > a column.
> >
> > =COUNT($AL$1000:$AL$5000,"<=today()")
> >
> > I need to change it so that it counts the dates between today and the
> > last 3 months.
> >
> > Can someone tell me how, I have tried all manner of configurations.
> >
> > Many thanks
> >
> > Joe
> >
>

Check your other posts, too.

deaconj999 wrote:
>
> Hi All,
>
> At present I have a formula that counts the number of date entries in
> a column.
>
> =COUNT($AL$1000:$AL$5000,"<=today()")
>
> I need to change it so that it counts the dates between today and the
> last 3 months.
>
> Can someone tell me how, I have tried all manner of configurations.
>
> Many thanks
>
> Joe

--

Dave Peterson

Nick,
Sorry -- just forget what I just wrote - I just came back to look this over,
and I'm not half-way sure what I said is right or not, I'm nearly brain-dead
status..
Jim

"Nick Hodge" wrote:

> This may work
>
> =COUNTIF($AL$1000:$AL$5000,"<"&DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY())))
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> (E-Mail Removed)DTHIS
> web: www.nickhodge.co.uk
> blog: www.nickhodge.co.uk/blog/
>
> FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
> www.officeusergroup.co.uk
>
> "deaconj999" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi All,
> >
> > At present I have a formula that counts the number of date entries in
> > a column.
> >
> > =COUNT($AL$1000:$AL$5000,"<=today()")
> >
> > I need to change it so that it counts the dates between today and the
> > last 3 months.
> >
> > Can someone tell me how, I have tried all manner of configurations.
> >
> > Many thanks
> >
> > Joe
> >
>

Here is another formula:
=SUMPRODUCT(($AL$1000:$AL$5000<=TODAY())*($AL$1000:$AL
$5000>=EDATE(TODAY(),-3)))

Hth,
Merjet