fORMULA

[VbaHell]

Hello one and all
I am using excel 2007

I require a forumla please to complete the following

Row a1 has dates

I would like to count the number of rows which has a date populated in the cell which is "<=(Today()"

Any help would be great please

 

[VoG]

Try

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

 

[VbaHell]

Thanks peter

Can I ask another question

I would also like to add another countif statement

=COUNTIF(A:A,"<="&TODAY()) +COUNTIF(B:B,"APPLE")

So the result would be if cell B:B = apple and cell A:A <= Today()

 

[VoG]

Try like this

=SUMPRODUCT(--(A1:A100<=TODAY()),--(B1:B100="APPLE"))