How to set the function - countif?

  • Thread starter Thread starter Eric
  • Start date Start date
E

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
 
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
 
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
 
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
 
Back
Top