Counting Dates less then today
 

I have a column that I would like to have a count of all the dates that are
less then today's date.

I have tried: =countif(d2:d25,"<TODAY",0) This has only gotten me 0. If I
leave the " " out then I get an error message. What do I need to do?

Thanks in Advance.

=COUNTIF(D2:D25,"<"&TODAY())

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a column that I would like to have a count of all
the dates that are
less then today's date.

I have tried: =countif(d2:d25,"<TODAY",0) This has only
gotten me 0. If I
leave the " " out then I get an error message. What do I
need to do?

Thanks in Advance.
.

Thanks Jason--Worked great.

"Jason Morin" wrote:

=COUNTIF(D2:D25,"<"&TODAY())

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a column that I would like to have a count of all
the dates that are
less then today's date.

I have tried: =countif(d2:d25,"<TODAY",0) This has only
gotten me 0. If I
leave the " " out then I get an error message. What do I
need to do?

Thanks in Advance.
.