Counting Dates

[Sing01]

I need to count the number of dates that fall on or before a given date ie...the given date is 12jan05 and I have the following dates:

11dec04
10nov04
15feb05
21mar05

In this example the answer should be: 2 If the data date were 15feb05, the answer would be 3

I tried using countif(range;"<=data date") where data date is the cell address of the data date (12jan05). I need a simple solution...an array might be a problem

Thanks in advance

 

[tactps]

Tyep the date you want to chack in (say) cell B1.

Then:
=countif(range,"<=B1")

This assumes that the data is formatted values.

 

[Sing01]

This is the formula I have been using, but for some reason it keeps returning 0 instead of expected answer (3). You are probably right...has something to do with date format

Can you explain what type of date format I should be using....

Really need to get this to work

Thanks

 

[tactps]

This will work. Any format will do:
=SUMPRODUCT(--($A$1:$A$4<=B1))

 

[Sing01]

Works like a charm.....Thanks

 

[Aladin Akyurek]

This will work. Any format will do:
=SUMPRODUCT(--($A$1:$A$4<=B1))

No, any format won't do. That formula requires true dates.

BTW, you wrote:

=countif(range,"<=B1")

while it should be:

=COUNTIF(Range,"<="&B1)