count the number of cells within a column with a date <= today's d

[Guest]

I need to count the number of cells within a column that contain a date that
is less than/equal to today's date. What formula can I use to do this?

 

[Guest]

Try this:

=COUNTIF(A1:A100,"<="&TODAY())

HTH,
Elkar

 

[Anne Troy]

This is the 3rd time you have asked the same question. What is wrong with
the answers you're receiving?
************
Hope it helps!
Anne Troy
www.OfficeArticles.com