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

Try this:

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

HTH,
Elkar

"Cachod1" wrote:

I need to count the number of cells within a column that contain a date that
is less than/equal to today's date. What formula can I use to do this?