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

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<=DA TE(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
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"sailingscotts" wrote in message
...
Using excel, how would you count occurances of dates that fall between 2
dates? Thank you,
sailingscotts

Thank you, Max!

"Max" wrote:

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<=DA TE(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
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"sailingscotts" wrote in message
...
Using excel, how would you count occurances of dates that fall between 2
dates? Thank you,
sailingscotts

You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"sailingscotts" wrote in message
...
Thank you, Max!