Thanks Bob, I tried the second formula because there are other number in
column A, but I still just get a zero as an answer. Does the date have to be
in a certain format?

"Bob Phillips" wrote:

If the other data is not numbers you can use

=SUMPRODUCT(--ISNUMBER(A1:A100))

if there could be other numbers, then if you know the start and end dates
you could use

=SUMPRODUCT(--(A1:A100=DATE(2005,1,1)),--(A1:A100<=DATE(2005,12,31)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"aaronwexler" wrote in message
...
In a worksheet of mine I have a bunch of dates in column A in the format
dd/mm/yyyy. I also have data in between the dates in that column and I
was
wondering if there was a formula that will count the number of dates.

Thanks Aaron