Hello all,

First post so forgive me in advance if posting is incorrect. Straight to the point. Here is what I am trying to do:

I have a column of contract dates (6/7/06, 8/14/09 etc.) and I would like to set up a cell to count the number of contracts written between specific dates. So, for instance, if I enter the date 10/12/09 in cell A1, I would want cell A2 to count the number of contracts written between 10/5/09 and 10/11/09.

This was my thought: COUNTIF(b1:b300,AND(b1:b300>=(a1-7),b1:b300<=a1-1)

This formula does not return an error, but does not give the correct output.

Questions: Is COUNTIF the right function to use for this purpose? Can I use the AND function of I want to have multiple conditions? Also, is there always issues when adding and subtracting from dates (ie, a1-7) and is it best to avoid doing that if possible and just stick to referencing cells?

Thanks in advance for any help.

Brandon