Joel ... (Hi)

I finally got this with Sumproduct ... I forgot that you can't use Col Ref
when using this great function & it took me awhile to figure it out ...

Thanks for supporting these boards ... Kha

"joel" wrote:

=sumproduct(--(A1:A100=datevalue("1/1/09")),--(A1:A100<=datevalue("3/31/09")))

"Ken" wrote:

Excel2003 ... Col "H" contains Dates (mm/dd/yy), Text comments & Empty Cells.

I wish to count dates by Qtr (excl Text) ... How many dates occurred between?

01/01/09 to 03/31/09
04/01/09 to 06/30/09
07/01/09 to 09/30/09
10/01/09 to 12/31/09

Sumproduct keeps giving me the "NUM" error ... Countif keeps counting the
Text.

Above said ... I am fully aware this is a short-coming on my part ... :)

Thanks for a solution ... Kha