=SUMPRODUCT(--MONTH(A2:A20)=6))

=SUMPRODUCT(--(MONTH(A2:A20)=6),--(B2:B20="No"))

--
HTH

Bob Phillips

"Todd Nelson" wrote in message
...
I am having trouble coming up with a countif formula for dates. i need it
to
count anything submitted with a particular month, and also then a formula
to
count the next column. example

june 7 yes
june 14 no
May 21 yes
June=2
June No= 1
Does that make sense?