View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JMB
 
Posts: n/a
Default count the number of cells with a date <= today's date

If the data is in cells A1:A3

=COUNTIF(A1:A3, "<="&TODAY())

"Cachod1" wrote:

I need to count the number of cells in a column that contain a date that is
<= today's date. I've tried using a COUNTIF formula but it's not working.
HELP!