Formula to count number of days in range which are less than today

Duke Carey · 09-06-2005, 12:05 AM

Try:

=COUNTIF(a1:a100,"<"&TODAY())

"zooming" wrote:

> Could anyone proivide me with a formula that will allow the following:
>
> I have a range of dates and I would like to count the number of dates that
> are less than todays date.
>
> I have inserted =today() for the current date then tried the counif
> function, however no joy.
>
> Can anyone help
>
> Thanks
>
> MM

zooming · 09-06-2005, 12:05 AM

Duke

Thanks for your help works great

"Duke Carey" wrote:

> Try:
>
> =COUNTIF(a1:a100,"<"&TODAY())
>
>
> "zooming" wrote:
>
> > Could anyone proivide me with a formula that will allow the following:
> >
> > I have a range of dates and I would like to count the number of dates that
> > are less than todays date.
> >
> > I have inserted =today() for the current date then tried the counif
> > function, however no joy.
> >
> > Can anyone help
> >
> > Thanks
> >
> > MM

zooming · 09-06-2005, 06:05 AM

Could anyone proivide me with a formula that will allow the following:

I have a range of dates and I would like to count the number of dates that
are less than todays date.

I have inserted =today() for the current date then tried the counif
function, however no joy.

Can anyone help

Thanks

MM

Duke Carey · 09-06-2005, 06:05 AM

Try:

=COUNTIF(a1:a100,"<"&TODAY())

"zooming" wrote:

> Could anyone proivide me with a formula that will allow the following:
>
> I have a range of dates and I would like to count the number of dates that
> are less than todays date.
>
> I have inserted =today() for the current date then tried the counif
> function, however no joy.
>
> Can anyone help
>
> Thanks
>
> MM

zooming · 09-06-2005, 06:05 AM

Duke

Thanks for your help works great

"Duke Carey" wrote:

> Try:
>
> =COUNTIF(a1:a100,"<"&TODAY())
>
>
> "zooming" wrote:
>
> > Could anyone proivide me with a formula that will allow the following:
> >
> > I have a range of dates and I would like to count the number of dates that
> > are less than todays date.
> >
> > I have inserted =today() for the current date then tried the counif
> > function, however no joy.
> >
> > Can anyone help
> >
> > Thanks
> >
> > MM