Count if for Date??

[koda86]

Hi,
i have a problem with the formula Count If, i would like to count in a column the number of date < to another date: for example, when i write 31/12/2006 in J1 would like to count all the dates in the column F before 31/12/2006.

=COUNTIF('Global Sheet'!F5:F499,"<J1")

i don t know why it does not work!


Thank you

[oldchippy]

Try

=COUNTIF('Global Sheet'!F5:F499,<"31/12/2006")

[Carim]

Hi,

=COUNTIF('Global Sheet'!F5:F499,"<"&J1)

HTH
Carim

[koda86]

I tried both but it still does not work!!

Thank you for your answers

[Carim]

Hi,

Would you mind uploading a zipped copy of your worksheet ...?
cause both formulae work under normal circumstances ...

HTH
Carim

[koda86]

Sorry
the second solution works perfectly!!!
thank you again!

[Carim]

Glad your problem is fixed

Thanks for the feedback

Carim

[oldchippy]

Sorry should have tried it first

=COUNTIF('Global Sheet'!F5:F499,"<31/12/2006")