If you're using Excel 2007...

A2:A25 = names
B2:B25 = dates

D2 = target date
E2 = some name

=COUNTIFS(A2:A25,E2,B2:B25,"<"&D2)

--
Biff
Microsoft Excel MVP


"MusicMan" wrote in message
...
I have two col. one with names, the second with dates.

I need a COUNT of a specific persons dates before xx/xx/xx.

I can count either with countif but fail when I try to combine.