Hi
if you are using XL2007, try this COUNTIFS

=COUNTIFS(A:A,""&DATE(2005,8,1),A:A,"<"&DATE(2008 ,7,31),B:B,"19")
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Raquel" wrote:

I have a spreadsheet that I am trying to do a count if formula on. The first
column contains a date. The second column contains a number. I want to
count if Column A has a date between 8/1/2005 and 7/31/2008 and if column B
has 19 in it. Is anyone familiar with this?