Hi

Try this one:

=COUNTIF(A1:A10,"=01/11/2009")-COUNTIF(A1:A10,"30/11/2009")

Regards,
Per

"gooders" skrev i meddelelsen
...
Hi, this seems to be a very simple query but obviously too hard for my
brain.
I have a column full of dates i.e.22/11/2009, 1/12/2009 etc. I may have
duplicates which isn't a problem. What I want to do is count the number of
rows that say were done in the month of November etc. I use Excel 2003.

Many thanks for any assistance.