how would I count dates (not # of days) in cells that fall betwee.

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

Guest

Using excel, how would you count occurances of dates that fall between 2
dates? Thank you,
sailingscotts
 
One way ...

Assuming the dates are real dates, and in A1:A100 down:
try something like this in say, B1:

=SUMPRODUCT((A1:A100>=DATE(2005,7,1))*(A1:A100<=DATE(2005,7,15)))

which counts the # of cells within A1:A100 with dates
between 1st July 2005 and 15th July 2005 (inclusive)

Adapt to suit. Note that we can't use entire col references in SUMPRODUCT
 
Thank you, Max!

Max said:
One way ...

Assuming the dates are real dates, and in A1:A100 down:
try something like this in say, B1:

=SUMPRODUCT((A1:A100>=DATE(2005,7,1))*(A1:A100<=DATE(2005,7,15)))

which counts the # of cells within A1:A100 with dates
between 1st July 2005 and 15th July 2005 (inclusive)

Adapt to suit. Note that we can't use entire col references in SUMPRODUCT
Click to expand...
 
Back
Top