I have two columns which both contains dates. I want a count based on
criteria from the dates. For example...

Start Date End Date
01/01/08 12/31/08
3/15/07 12/01/09
5/5/09 10/01/09
10/01/08

How would i get a total count of items that started before 06/01/08 and
ended after 06/01/09.

it would be 1 in the example above.

Thanks

Try this

=SUMPRODUCT((A2:A20>DATE(2008,6,1))*(B2:B20<DATE(2009,6,1)))

Mike

"AccessNoviceButTrying" wrote:

> I have two columns which both contains dates. I want a count based on
> criteria from the dates. For example...
>
> Start Date End Date
> 01/01/08 12/31/08
> 3/15/07 12/01/09
> 5/5/09 10/01/09
> 10/01/08
>
> How would i get a total count of items that started before 06/01/08 and
> ended after 06/01/09.
>
> it would be 1 in the example above.
>
> Thanks

With start and end dates in cells c1 and D1 try the below

=SUMPRODUCT((A2:A10<C1)*(B2:B10>D1))

If this post helps click Yes
---------------
Jacob Skaria


"AccessNoviceButTrying" wrote:

> I have two columns which both contains dates. I want a count based on
> criteria from the dates. For example...
>
> Start Date End Date
> 01/01/08 12/31/08
> 3/15/07 12/01/09
> 5/5/09 10/01/09
> 10/01/08
>
> How would i get a total count of items that started before 06/01/08 and
> ended after 06/01/09.
>
> it would be 1 in the example above.
>
> Thanks