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

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
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"sailingscotts" <sailingscotts@discussions.microsoft.com> wrote in message
news:9956EDF5-D2C7-4B6C-B18A-E93A5D173D65@microsoft.com...
> 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<=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
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
> "sailingscotts" <sailingscotts@discussions.microsoft.com> wrote in message
> news:9956EDF5-D2C7-4B6C-B18A-E93A5D173D65@microsoft.com...
> > 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" <sailingscotts@discussions.microsoft.com> wrote in message
news:E6F8B09D-7C05-4AE6-A574-27615A351B30@microsoft.com...
> Thank you, 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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"sailingscotts" <sailingscotts@discussions.microsoft.com> wrote in message
news:9956EDF5-D2C7-4B6C-B18A-E93A5D173D65@microsoft.com...
> 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<=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
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
> "sailingscotts" <sailingscotts@discussions.microsoft.com> wrote in message
> news:9956EDF5-D2C7-4B6C-B18A-E93A5D173D65@microsoft.com...
> > 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" <sailingscotts@discussions.microsoft.com> wrote in message
news:E6F8B09D-7C05-4AE6-A574-27615A351B30@microsoft.com...
> Thank you, Max!

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"sailingscotts" <sailingscotts@discussions.microsoft.com> wrote in message
news:9956EDF5-D2C7-4B6C-B18A-E93A5D173D65@microsoft.com...
> 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<=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
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
> "sailingscotts" <sailingscotts@discussions.microsoft.com> wrote in message
> news:9956EDF5-D2C7-4B6C-B18A-E93A5D173D65@microsoft.com...
> > 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" <sailingscotts@discussions.microsoft.com> wrote in message
news:E6F8B09D-7C05-4AE6-A574-27615A351B30@microsoft.com...
> Thank you, Max!