countif a date is greater than today

Hi,
How can a range of cells that are dates be counted if the date in the cell
is prior to today.
--
Keith

=COUNTIF(Date_Range,"<"&TODAY())

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Keith" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> How can a range of cells that are dates be counted if the date in the cell
> is prior to today.
> --
> Keith
>
>

Thanks!

"Peo Sjoblom" <[email protected]> wrote in message
news:#tGY21E#[email protected]...
> =COUNTIF(Date_Range,"<"&TODAY())
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please, for everyone's
> benefit keep the discussion in the newsgroup/forum)
>
>
>
> "Keith" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> > How can a range of cells that are dates be counted if the date in the
cell
> > is prior to today.
> > --
> > Keith
> >
> >
>
>

Thanks

"Peo Sjoblom" <[email protected]> wrote in message
news:#tGY21E#[email protected]...
> =COUNTIF(Date_Range,"<"&TODAY())
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please, for everyone's
> benefit keep the discussion in the newsgroup/forum)
>
>
>
> "Keith" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> > How can a range of cells that are dates be counted if the date in the
cell
> > is prior to today.
> > --
> > Keith
> >
> >
>
>