Hi guys,
I have a large list of dates and need to count the occurrence of months in given years (so that July 2013 and July 2014 don't cause double ups for example).
The formula I entered
"=COUNT(IF(AND(YEAR(C2:C176)=2013,MONTH(C2:C176)=7),C2:C176,0))"
returns a value of 1 (incorrect). If I take out the AND function and use EITHER MONTH or YEAR the function returns the correct individual values as is needed.
Any thoughts?
Regards,
Abid
Bookmarks