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

=COUNTIF(B1:B100,"<"&TODAY())
Bb Umlas
Excel MVP
"Cachod1" wrote in message
...
I need to count the number of cells in one column that contain a date that

is
<= today's date. The dates are currently formatted as "General" numbers
rather than being formatted as "Date"