It seems something quite simple but i just can't get my formula to work. What i got so far is:
=COUNTIF(MASTER!c3:c999, DATE(YEAR(MASTER!c3:c999),MONTH(MASTER!c3:c999),1)=DATE(YEAR(B10),MONTH(B10),1))
what im trying to do is count how many rows contain the month x, and the year y (in this case i've entered the value 01/11/2006 in cell b10, and so should find out the number of rows in november 2006)
the c column on the master sheets contains various dates.
Unfortunatalty all i get returned from this forumla is 0.
What am i doing wrong?
Bookmarks