Hi

I have a spreadsheet where I want to multiply the number of dates that
appear in a column between a range by a value.


I have used the following formula to count the number of date entries
that have a value of greater than 0 (or 0/01/1900 as it is formatted)
and then multiplied it by 600 to get a $ value for the number of dates
in that column.
=COUNTIF($W$3:$W$1000,"0")*600

But because the formula brings dates that could be in the future, I
only want to include dates up to the current date ie today's date.

Any ideas?

cheers
Debbie