Counting a date range

Hi,

Can anyone tell me what the formula would be to do a count of all the dates in a certain column that is less than or equal to todays date?

I have got the following so far but it doesn't work, it just gives me back 0 even though it should be an amount:

=COUNTIF('Master data'!AW6:AW1000,"<=today_date")

I would really appreciate any help

Thanks

Hi

If you have the date you wish to use in a cell, e.g. A1 then the following formula will work

Please Login or Register  to view this content.

Regards

Jeff

Your criterion is:
"<="&TODAY()


HTH

Also - Jeff's solution is better if you're using this a lot (long column for example) as today() is volatile (google it) so it's better to use it as little as possible. You would probably need to make the reference absolute though ($A$1).

CC

Thanks! that worked great!

Appreciate the help