Thanks for the quick reply Bob, but isn't this the same as doing:

=COUNTIF(B:B,""&(TODAY()-30))

This does give me the number of Dates that are less than 30 days old but I
need to break this number down by the names in column A.

E.G

A B
Andy 01/Feb/2006
Andy 20/Mar/2006
Bob 04/Jan/2006
Bob 22/Mar/2006
Bob 26/Mar/2006

I would like the results to say:

Andy 1
Bob 2

As this is the number of "less than 30 day" dates for each person.

Is that possible?

"Bob Phillips" wrote:

=SUMPRODUCT(--(DATE(YEAR(TODAY()),MONTH(B1:B20),DAY(B1:B20))=TO DAY()-30),
--(DATE(YEAR(TODAY()),MONTH(B1:B20),DAY(B1:B20))<=TO DAY()))

--
HTH

Bob Phillips