D1:D36 have dates. =COUNTIF(D1:D36,">4/12/2011") gives the cells > 4-12-2011. What if I want to count the cells > today()?