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

S

sailingscotts

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

Max

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
 
S

sailingscotts

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
--
Rgds
Max
xl 97
Click to expand...
 
Top