COUNT if Date is between two dates.

G'day guys,
Long time listener, first time caller.

I'm trying to find a formula that will count the number of times an 'item' is beding used within the same date range.
- this is essentially the same thing as Resource Usage in Microsoft Project, but I need it in Excel.

This is what I have thus far:
A B C D
1 Item Number Start Date Finish Date Calculation
2 A1152 2/01/2014 12/01/2014 =COUNTIFS(A:A,A1,B:B,">="&B2,C:C,"<="&C2)
3 A1152 1/01/2014 11/01/2014
4 B2263 2/01/2014 12/01/2014
5 B2263 1/01/2014 11/01/2014
6 A1152 3/01/2014 13/01/2014


The result should be '3', given that the same 'Item' is being used 3 times withing the same timeframe (for Item Number A1152).

Any assistance would be greatly appreciated, as I've been stuck on this for Days!!

Cheers
Steve

@etaf: No the answer is 3, as I believe the OP is attempting to determine if there was ANY overlap of the dates, not a complete overlap/nesting of the dates.

@ajryan88, how funny, another Novocastrian.
what you have done there is So close, but I think you've nailed it when you said that I'm looking for ANY overlap.

I've attached a file of what I am trying to achieve (a simple version of a greater file).

If there are any overlaps, it should couny it. with the formula that you provided, it's not counting all.

The problem was that you translated the formula incorrectly.

In the attachment, I have setup some Named Ranges for you so that your formulae aren't looking up ENTIRE columns, rather just the cells that need to be looked up, and I have corrected your formulas.

My formula said

Formula:

Please Login or Register  to view this content.

and your formula was translated incorrectly as below, shown in red:

Formula:

Please Login or Register  to view this content.

I hope this helps

That is amazing, absolutely amazing.
Thank you so much ajryan88

You're welcome Glad I could help.

Please don't forget to mark this thread as solved, and please click on the * next to my post to say thanks and add to my reputation