For the 1st try: =COUNT(IF(MONTH($B$20:$B$507+0)=MONTH(D$6),1,"")) confirmed with CTRL+SHIFT+ENTER..

I don't see where the 2nd applies...?