How to set the function - countif?

[Eric]

Does anyone have any suggestions on how to set the function - countif?
There is a list of date under column A, and there is a given date in cell B1,
I would like to count the date only match the month and day without
concerning the year, and return the number in cell B2.
For example,
Under column A,
11-Dec-2008
13-Jun-2007
14-Apr-2008
14-Apr-2006
The given date is 14-Apr-2003 in cell B1, and it should return 2 in cell B2,
because
14-Apr-2008 and 14-Apr-2006 match the given date 14-Apr-2003 in term of
month and day.
Does anyone have any suggestions on how to set the formula?
Thanks in advance for any suggestions
Eric

 

[Gary''s Student]

=SUMPRODUCT((MONTH(A1:A100)=MONTH(B1))*(DAY(A1:A100)=DAY(B1)))

SUMPRODUCT() should always be considered if you are using more than one
criteria.

See:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Eric]

Thank everyone very much for suggestions
I receive 0 instead of 2 from following code.
=SUMPRODUCT((MONTH(A1:A100)=MONTH(B1))*(DAY(A1:A100)=DAY(B1)))
What wrong is it?
Thank everyone very much for any suggestions
Eric

 

[Eric]

I need to cover a table, which include blank space "", which cause the error,
but I cannot skip those blank space "".
Does anyone have any suggestions on how to avoid those error because of this
blank space within table from A1 to Z36? and return 2 in cell B2
Thank everyone very much for suggestions
Eric

 

[Eric]

Thank everyone very much for suggestions
I don't solve this problem, but replace the character "" with 0, and this
formula is working.
Thank everyone very much
Eric