Excel 2007 : Need Countifs Formula to count dates between 2 dates,

I am stumped.
I have column C that shows dates. Cell A1 has start date & B1 has end dates
I want to count each row that has a date on or between A1 & B1

=countifs(c2:c1500,=>a1,c1:c1500,=<b1)

This gives me error.
Any suggestion? And, if the formula worked would it give me a count of the dates between a1 & b1 - or would it give me a count of all the dates greater than a1 + all the dates less than b1?

Hi Crimedog,

Use:

=COUNTIFS(C1:C15,">="&A1,C1:C15,"<="&B1)

It will only count the dates between the two dates in A1 and B1.

Try:

=countifs(c2:c1500,">="&a1,c1:c1500,"<="&b1)