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?

Use your formula like this...

=COUNTIF(B11:B396,"<"&TODAY())

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Bob" wrote:

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?

You are close:

=COUNTIF(B11:B396, "<" &TODAY())

Regards,
Per

"Bob" skrev i meddelelsen
...
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?

=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?

=COUNTIF(B11:B396, "<TODAY()") is looking for the text string "<TODAY()"
Try =COUNTIF(B11:B396, "<"&TODAY())
--
David Biddulph

"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?