CountIF Function for dates

Hi All, Just need a little help with a formula. I want a formula that will count a column of data and let me know how many of the dates in the column are before a set date. e.g. how many dates in the column are before 08/5/06?

Chris

Currnetly using =COUNTIF(D$10:D$155,"<08/04/2006")

how can i suplement the date of 08/04/06 with a cell reference with an ever changing number?

Chris

As suggested above, use SUMPRODUCT:

=SUMPRODUCT(--(D$10:D$155<F1))

Where F1 is the referenced date cell.

HTH

Jason

Great, the sum product formula works but i need it to exclude blank cells, any idea how to do this?

Chris

Sure:

=SUMPRODUCT(--(D$10:D$155<F1)*(D$10:D$155<>""))