counting based on two dates

  • Thread starter AccessNoviceButTrying
  • Start date
A

AccessNoviceButTrying

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LOOKUP function between two dates in Excel 2007 6
Count Dates between Dates exclude Text 3
Dates & Text? 6
How to Count Dates in 2 Lists 2
dates inbetween 3
macro help 1
Count based on multiple criteria 2
KPI Data Chart Display 1

Top