Countif - problem when using date as criteria

[pigionweb]

Hello everyone,

here is what I need to do: I got a list of dates and need to count those above let's say 23-apr-14. Pretty simple, so I write:

=COUNTIF(M10:M37,">=23-apr-14")

this works just fine, correctly returns 6, all nice.

Now I will need to change the treshold date from time to time and will have the formula in many cells, so I put the treshold date 23-apr-14 in a cell, let's say K6, and change the formula to this:

=COUNTIF(M10:M37,">=K6")

Here the trouble start's, the reults shows 0, no matter what I tried to do.

Do you have any ideas, why could the formula work when date entered directly, but not when referenced from other cell?

 

[bbott]

You're telling it to count cells that have the text "K6". Try it like this:

=COUNTIF(M10:M37,">="&K6)

 

[pigionweb]

Wow, that was quick... lovely and solved Many thanks!

 

[bbott]

Wow, that was quick... lovely and solved Many thanks!

You're welcome.