Given use of XL2007 you could try using COUNTIFS:

=COUNTIFS(A:A,"<"&TODAY(),B:B,"")
modify ranges as appropriate