I need some help with a formula. I'm trying to count the NOT BLANK cells in range C4:C17 that are between 8/1/2016 and 8/31/2016 (cells B4:B17). My formula is returns a value of 30, I'm expecting an answer of 5. I would appreciate help correcting my formula. See attached.
Here's my formula in F4: =COUNTA(C4:C17,B4:B17,">="&E4,DATE,"<="&EOMONTH(E4,0))
Thank you.