Count between a Date Range

[Miguelre]

I have a number of columns that has dates in them and blank cells, and
would like to count the number of instances a date’s falls in betwee
current date and earlier. I have not been successful using the eithe
the Countif ,Sumif, or Sumproduct formula.

Can someone please assist me, because I have been racking my brain ove
this for 3 days now

 

[Frank Kabel]

Hi
try:
=SUMPRODUCT(--(A1:A100>=DATE(2004,9,1)),--(A1:A100<=TODAY()))