COUNTIF formula problems. Excel 2010

[impschocok]

I am trying to write a formula that will count the number of due dates older than TODAY() so long as the corresponding cell in Column B is blank (not completed). So in the table below considering a today date of 9/5/2014, my formula should return 2. I have tried several COUNTIFS formulas but just cant get it to work.

	A	B	C
1	Due Date	Date Completed
2	8/1/2014	7/25/2014
3	8/1/2014
4	8/1/2014	7/28/2014
5	8/1/2014
6	10/1/2014

<tbody>
</tbody>

Thank you for your assistance.

 

[Weazel]

maybe...

Excel 2012

	A	B	C	D
1	Due Date	Date Completed		Count
2	8/1/2014	7/25/2014		2
3	8/1/2014
4	8/1/2014	7/28/2014
5	8/1/2014
6	10/1/2014

<tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula D2 =COUNTIFS(A2:A6,"<"&TODAY(),B2:B6,"") <tbody> </tbody>

<tbody>
</tbody>