Thread
:
Countif function
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Countif function
=COUNTIF(A11:A396, "<"&TODAY())
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Bob" wrote in message
...
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett