View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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