COUNTIF and TODAY()

[moltar]

I am trying to count the number of cells that have date values equal to or less than today's date.

The formula is in A1, and the contents of A22 is as follows:

A2 = 01/01/2004
B2 = 02/01/2004
C2 = 03/01/2004
D2 = 04/01/2004

=COUNTIF(A22,"01/1/2004")

This formula results in a value of 1. How do I change it to swap the criteria's static date to either NOW() or TODAY()? When I do that, such as with

=COUNTIF(A22,"<=TODAY()")

then it just results in 0.

Help!

 

[SkipVought]

Hi,

If you were to enter =TODAY() in B1 then
[tt]
=COUNTIF(A2:A11,"<"&B1&"")
[/tt]


Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[TonyJollans]

Hi moltar,

You need to have TODAY() outside the quotes to have it interpreted as a Function instead of a literal. Try entering ..

[blue][tt]=COUNTIF(A22,"<="&TODAY())[/tt][/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.