Countif criteria

[GaryB]

I'm sure this must be simple but it's driving me nuts - I'm trying to count all the dates in a column that are in the future, but the syntax is beating me.
=COUNTIF(A:A,TODAY()) counts all the examples with todays date, but what have I got to do to change the formula to count if >today() - adding the ">" produces a helpful "The formula you typed contains an error" message.

Thanks for your time

GaryB

 

[Ian Mac]

On 2002-04-05 01:05, GaryB wrote:
I'm sure this must be simple but it's driving me nuts - I'm trying to count all the dates in a column that are in the future, but the syntax is beating me.
=COUNTIF(A:A,TODAY()) counts all the examples with todays date, but what have I got to do to change the formula to count if >today() - adding the ">" produces a helpful "The formula you typed contains an error" message.

Thanks for your time

GaryB

you need to put ""'s round the > and and &.

=COUNTIF(A:A,">"&TODAY())

It's funny because you did the ">" in your question.

 

[GaryB]

Doh!! How dumb do I feel?

Thanks for that Ian

G