Hi guys,

I have a spreadsheet with a lot of columns. Column B contains date values against each row in the format 09-Apr-08.

I want to be able to use the COUNT function to count values in column C between 2 dates I specify. So for example, if I may want to count the number of numerical values in column C between say 01-Jan-08 and 09-Apr-08.

Is there a way I can maybe enter the 2 date values in seperate cells and have a formula come up with a corresponding range to perform the count function over? I was initially wondering whether I could do this by a vlookup but the column with the dates in is column B (i.e. not the left most column).

The other issue here is that the start and end dates may not necessarily correspond exactly to the numbers given above. For example, whilst I may be wanting to count the values between 01-Jan-08 and 09-Apr-08, the first value in column B in that range may be 04-Jan-08 so when establishing the range it would need to only approximately consider the dates I specify.

Hope someone can help!

Cheers,

Christian