Hi Susanne,

Assuming that your data are in range [A2:B10] try the following:

=SUMPRODUCT((MONTH(A2:A10)=11)*(YEAR(A2:A10)=2004) *((MONTH(B2:B10)<11)+(YEAR(B2:B10)<2004)0))

Regards,
KL

"Susanne" wrote in message
...
I need to count a numbers of entries in a given month and then I have to
compare with another set of entries that has to be greater than a certain
month. I also has to count the numbers of empty cells. Can I use a nested
IF
function ?

It looks like this :

Date in Date finished
01-11-2004 03-01-2005
30-11-2004

I now want to calculate how many entries entered in November but not
finished in November. I want this for every month of the year.

Susanne