One way:

pre-XL07:

=SUMPRODUCT(--(A1:A100=DATE(2008,1,1)),
--(A1:A100<=DATE(2008,12,31)), --ISNUMBER(B1:B100))


XL07,ff:

=COUNTIFS(A:A,"=1/1/2008",A:A,"<=12/31/2008")


In article ,
John Peterson <John wrote:

Attempting to obtain a count on the number of records with values populated
in a particular field that are between a date range. Have tried the
different count functions and cannot seem to get this to work. Any ideas on
how best to approach this?
John