=SUMPRODUCT(--(A2:A4=DATEVALUE("1/1/2006")),--(A2:A4<=DATEVALUE("31/3/2006")),--(B2:B4=DATEVALUE("1/1/2007")),--(B2:B4<=DATEVALUE("31/3/2007")))

Adjust ranges to real situation!
Regards,
Stefi


€žSumeth€� ezt Ã*rta:

Any one could help me pls.
I have a spreadsheet that I want to count records like this.

A B
Start Retile
1/1/2006 1/2/2007
1/1/2006 20/4/2007
15/6/2006 10/4/2007

I would like to count start is between 1/1/2006 to 31/3/2006 and
retile is between 1/1/2007 to 31/3/2007

Thank you so much
kim