Thread: How do I get the COUNTIF criteria to recognize only month and yea.
View Single Post
  #4   Report Post  
Harlan Grove
 
Posts: n/a
Default
"Aladin Akyurek" wrote...
=SUMPRODUCT(--(TEXT(A2:A5,"mmm-yy")=TEXT(E2,"mmm-yy")))

Why convert to text?

=SUMPRODUCT(--(A2:A5-DAY(A2:A5)=E2-DAY(E2)))


Reply With QuoteReply With Quote