count entries between specific dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi Wayne
try
=SUMPRODUCT((G1:G1000>=DATE(2003,10,1))*(G1:G1000<=DATE(2003,12,31))

HTH
Frank
 
Back
Top