Trying to isolate tasks completed in May

[Btanyf]

Hello,
So I have a list of tasks with a start & end date then a column with the business days it took to get from start to end. I need to know the amount of tasks that were completed in April and the amount of tasks that started in April but ended in May

(A1) April 7, 2011 (B1) May 9, 2011 (C1) 21 days
(A2) April 11, 2011 (B2) April 14, 2011 (C2) 4 days

So I need to find s formula that gives me 1 completed task for april and 1 completed task for may (they do not need to be the same formaula they can be separate)

If anyone can help that would be great...Thanks!

 

[Robert Mika]

D1: 01/04/2011
E1: 30/4/2011
F1: 30/05/2011

For April

=SUMPRODUCT(--($A$1:$A$18>D1),--($B$1:$B$18 < E1),--($B$1:$B$18 > D1))

<e1),--($b$1:$b$18><e1),--($b$1:$b$18><e1),--($b$1:$b$18>
For April-May

E3:=SUMPRODUCT(--($A$1:$A$18>D1),--($B$1:$B$18>E1),--($B$1:$B$18>D1),--(B1:B18 < F1))
<f1))

Adjust your ranges</f1))
</e1),--($b$1:$b$18></e1),--($b$1:$b$18></e1),--($b$1:$b$18>

 

[T. Valko]

Hello,
So I have a list of tasks with a start & end date then a column with the business days it took to get from start to end. I need to know the amount of tasks that were completed in April and the amount of tasks that started in April but ended in May

(A1) April 7, 2011 (B1) May 9, 2011 (C1) 21 days
(A2) April 11, 2011 (B2) April 14, 2011 (C2) 4 days

So I need to find s formula that gives me 1 completed task for april and 1 completed task for may (they do not need to be the same formaula they can be separate)

If anyone can help that would be great...Thanks!

Are the dates all within the same year?

What version of Excel are you using?

 

[Btanyf]

I will try the first answer above.

But for the second question, the dates are in my fiscal year 2011-2012 and I am using excel 2007.

Thanks for the formula posted above! lets see if it gives me what I want!