=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.
.
|