View Single Post
  #4   Report Post  
Domenic
 
Posts: n/a
Default

Try...

=COUNTIF(A:A,"=1/1/2005")-COUNTIF(A:A,"1/31/2005")

Hope this helps!

In article ,
"Dave" wrote:

Hi guys,

Hope someone can help with this, I'm pretty sure it'll be quite a simple one.

Column A:A contains a list dates, I want to use a formula to count the
number of cells which contain a date between 01/01/05 - 31/01/05.

Any ideas,

Many thanks,
Dave