count entries between specific dates

[Wayne]

I have about 20 dates in column G expressed as: 10/01/00 ... 01/31/04. I want to count the entries between 10/01/03 and 12/31/03. I've tried many formulas that don't work. Can anyone get me on the right track please?

 

[Frank Kabel]

Hi Wayne
try
=SUMPRODUCT((G1:G1000>=DATE(2003,10,1))*(G1:G1000<=DATE(2003,12,31))

HTH
Frank

 

[Wayne]

Thanks Frank, It works perfectly.