View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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

--
Regards,

Peo Sjoblom

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



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