Good morning, I have a column with dates (MM/DD/YY) and I'm trying to write a
formula that will look at this column and tell me which ones are older than
today. I tried =COUNTIF(B11:B396, "<TODAY()") which did not work. The only
way I could get a result was =COUNTIF(B11:B396, "<01/19/10"). The problem
with this is you have to enter today's date each time you open the file. Is
there not an easier solution?