CountIf function + dates

  • Thread starter Thread starter patricia
  • Start date Start date
P

patricia

Does this work with dates? I have a column of dates and
wanted to count the # of dates greater than or less than
todays date. I set the formula for =COUNTIF(C2:C21,">today
()")and it came back zero, I then changed the formula to <
today() and still zero. There are dates that are < and
 
Try this instead. The extra part is necessary to weed out blank cells which
have "dates of 0".

=SUMPRODUCT(--(C2:C21<TODAY())*(C2:C21<>""))
 
Back
Top