Count Dates
 

I have a list of dates in the following format MM/DD/YYYY.

1/11/2008
1/12/2008
1/30/2008
1/10/2008
1/10/2008
1/10/2008
1/12/2008
1/6/2008

I want to know how many times a date falls in-between a certain week. For
instance, countif(range,"=1/1/2008","<=1/6/2008"). It should be 1.

Any help?

Count Dates
 

=SUMPRODUCT(A2:A100=startdate)-SUMPRODUCT(A2:A100enddate)
--
John C


"Matthew Tyrus" wrote:

I have a list of dates in the following format MM/DD/YYYY.

1/11/2008
1/12/2008
1/30/2008
1/10/2008
1/10/2008
1/10/2008
1/12/2008
1/6/2008

I want to know how many times a date falls in-between a certain week. For
instance, countif(range,"=1/1/2008","<=1/6/2008"). It should be 1.

Any help?

Count Dates
 

Try this:

Enter you date boundaries in cells:

C1 = 1/1/2008
D1 = 1/6/2008

=COUNTIF(A1:A8,"="&C1)-COUNTIF(A1:A8,""&D1)

--
Biff
Microsoft Excel MVP


"Matthew Tyrus" wrote in message
...
I have a list of dates in the following format MM/DD/YYYY.

1/11/2008
1/12/2008
1/30/2008
1/10/2008
1/10/2008
1/10/2008
1/12/2008
1/6/2008

I want to know how many times a date falls in-between a certain week. For
instance, countif(range,"=1/1/2008","<=1/6/2008"). It should be 1.

Any help?