Hey Guys,

I want your guidance in building a formula that returns number of cells which contains specific period. The data stuff is as under:

(01) I’ve created a range named DateRange which contains dates in dd/mm/yyyy format; the range includes cells from a1:a15;

(02) I want to count number of cells in DateRange which contains date values from 01/05/2009 (which is entered at b4 address) to 31/05/2009 (which is entered at c4 address);

(3) I tried following formula:

= COUNTIF(DateRange, "AND(DateRange >= B4, DateRange <= C4)")

But I’m getting 0 as the result though the DateRange contains 7 entries between 01/05/2009 to 31/05/2009.

I seek your valuable guidance to get me out of this prob. Also mention correct remedy if I’m on the wrong track.

Thanks,