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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Due Date[/TD]
[TD]Date Completed[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8/1/2014[/TD]
[TD]7/25/2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]8/1/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]8/1/2014[/TD]
[TD]7/28/2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]8/1/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]10/1/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thank you for your assistance.

 

[Weazel]

maybe...

Excel 2012[TABLE="class: grid, width: 500"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="bgcolor: #FCE4D6"]Due Date[/TD]
[TD="bgcolor: #FCE4D6"]Date Completed[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FCE4D6"]Count[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FAFAFA, align: right"]8/1/2014[/TD]
[TD="bgcolor: #FAFAFA, align: right"]7/25/2014[/TD]
[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="bgcolor: #FAFAFA, align: right"]8/1/2014[/TD]
[TD="bgcolor: #FAFAFA, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="bgcolor: #FAFAFA, align: right"]8/1/2014[/TD]
[TD="bgcolor: #FAFAFA, align: right"]7/28/2014[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="bgcolor: #FAFAFA, align: right"]8/1/2014[/TD]
[TD="bgcolor: #FAFAFA, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="bgcolor: #FAFAFA, align: right"]10/1/2014[/TD]
[TD="bgcolor: #FAFAFA, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]D2[/TH]
[TD="align: left"]=COUNTIFS(A2:A6,"<"&TODAY(),B2:B6,"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]